topic Show Text Dynamically Based on Filter Selection in DAX Commands and Tips

Show Text Dynamically Based on Filter Selection

AvijitD_05 — Wed, 10 Jul 2024 07:54:08 GMT

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.

Re: Show Text Dynamically Based on Filter Selection

BeaBF — Wed, 10 Jul 2024 14:37:32 GMT

AvijitD_05 Hi!

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

SelectedCount =

IF(

HASONEVALUE('ColorsTable'[Colors]),

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

)

SelectedValueOrMultiple =

IF (

[SelectedCount] = 1,

VALUES('ColorsTable'[Colors]),

"Multiple"

)

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

BBF

Re: Show Text Dynamically Based on Filter Selection

Shaurya — Wed, 10 Jul 2024 12:00:46 GMT

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

Re: Show Text Dynamically Based on Filter Selection

Anonymous — Thu, 11 Jul 2024 06:41:33 GMT

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.