Forum Discussion

BenWei's avatar
BenWei
Frequent Visitor
9 years ago
Solved

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's avatar
    9 years ago

    BenWei

     

    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