Forum Discussion
BenWei
9 years agoFrequent Visitor
Dynamic calculate Column value based on Slicer Selection
Hi Everyone I just started using Microsoft Power BI recently, and this got stucked for few hours already. Hope someone could help me on this. This might be a simple question to the gurus. Her...
Vvelarde
9 years agoCommunity Champion
try with this:
A measure:
Applicable = if(HASONEVALUE(Table2[Applicabilities]),if(MID(VALUES(Table2[Applicabilities]),[SelectedIndex],1)=FORMAT([SelectedIndex],BLANK()),1,0))
In visual filter Put Applicable is not 0