Check if value is being used as a filter

[Anonymous]

Hello,

I'm using a column as a Power BI binary filter. The data frame is like:

So I'm using the column "Value" as a binary filter on my dashboard. I expect that when I select $ on visual my calculated column bring this:

Where 1 means that $ was selected by user.

Any ideas on how to generate dax capable of classifying whether the value was selected or not in the visual?

[Fowmy]

@Anonymous 

The values you in the table will not be affected by any selection being made from the filters. Hope your $ and % value column is on a slicer for the user to select, You need to get the value selected using SELECTEDVALUE('TABLE'[VALUE]) and incorporate it in the measures that need to be evaluated based on the selection.

Hope this made it clear.

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn