switch与rankx
2020-08-05 本文已影响0人
BI罗
base_switch = SWITCH(SELECTEDVALUE('name'[name]),"a",11,"b",6,"c",7)
rankx1 = RANKX(ALL('name'[name]),[base_switch])
base_switch = SWITCH(SELECTEDVALUE('name'[name]),"a",11,"b",6,"c",7)
rankx1 = RANKX(ALL('name'[name]),[base_switch])
