Forum Discussion

AvijitD_05's avatar
AvijitD_05
New Member
2 years ago
Solved

Show Text Dynamically Based on Filter Selection

Hello,   I am using a slicer in my report and I want show show the Text "Multiple", if more than one values are selected in the slicer.   For example, the Slicer has 4 values: Red, Blue, Black an...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi AvijitD_05 

     

    Thanks for the reply from BeaBF and Shaurya .

     

    AvijitD_05 , you can try the following measure.

    Measure = 
VAR _count = CALCULATE(COUNT('Table'[Color]), FILTER('Table', [Color] IN VALUES('Table'[Color])))
RETURN
IF(_count = 1, MAX([Color]), "Multiple")

     

    Output:

     

     

    Best Regards,
    Yulia Xu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi AvijitD_05 

 

Thanks for the reply from BeaBF and Shaurya .

 

AvijitD_05 , you can try the following measure.

Measure = 
VAR _count = CALCULATE(COUNT('Table'[Color]), FILTER('Table', [Color] IN VALUES('Table'[Color])))
RETURN
IF(_count = 1, MAX([Color]), "Multiple")

 

Output:

 

 

Best Regards,
Yulia Xu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.