Show Text Dynamically Based on Filter Selection

[AvijitD_05]

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 and Green. If I select only one colour it should come up on a card visual but I make more than colour selections let's say both Red and Green, then the card should show "Multiple".

Could you please help me with the DAX code, I should write for this problem?

Concatenatex is not what I am looking for as I am not trying to stack on additional values. 

[Anonymous · Accepted solution]

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.

[Shaurya]

Hi @AvijitD_05,

How about you count the selected values first:

SelectedColorCount = 
IF(
    ISFILTERED(YourTable[ColorColumn]),
    COUNTROWS(VALUES(YourTable[ColorColumn])),
    0
)

And then use:

SelectedColorDisplay = 
IF(
    [SelectedColorCount] = 0,
    "None Selected",
    IF(
        [SelectedColorCount] = 1,
        FIRSTNONBLANK(YourTable[ColorColumn], "None"),
        "Multiple"
    )
)

Mark this post as a solution if that works for you!
Check out this blog of mine: How to Export Telemetry Data from Azure IoT Central into Power BI  

[BeaBF]

@AvijitD_05 Hi!

Create these two measures and use the second in the card:

SelectedCount =

IF(

    HASONEVALUE('ColorsTable'[Colors]),

    1,

    COUNTROWS(VALUES('ColorsTable'[Colors]))

)

SelectedValueOrMultiple =

IF (

    [SelectedCount] = 1,

    VALUES('ColorsTable'[Colors]),

    "Multiple"

)

if it's ok, please mark the message as a solution

BBF