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
    Vvelarde
    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

     

     

ankitpatira's avatar
ankitpatira
Community Champion
9 years ago

Vvelarde Use of MIN() function is wrong there as it is always going to return minimum value from the table regardless of selection. You should use combination of HASONEVALUE and FIRSTNONBLANK functions. HASONEVALUE will let you check if the filter has been applied and is down to just one value, it will return TRUE or FALSE. FIRSTNONBLANK will return the first value. See this example. It is for different purpose but you can achieve your desired output using these two fuctions.

Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

Hi ankitpatira

 

I  dont understand when you say that a measure with Min Function always return the minimum value of a table regardless the selection.

 

I tested a slicer with indexes and select one of this. The measure with min(Index) return the selected index changing any time with the selection.

 

Maybe i missunderstood your explanation. Thanks for your comments.

 

 edit: In a calculated column Min return always the minimum value but in a measure changes with the context.