Dynamically choose Column A if all values of a Slicer are selected and Column B if there's one value

[Manick1012]

Hi all,

I have a Slicer selection based on a Chicklet. If no values are selected in the slicer (all selections), then i'll need to see Column A in my table (to be visualised in a graph). However, if there is even one value selected in the slicer selection, then I'll want to see Column B in my table.

How can I accomplish this ?

Regards,

Manick

[Anonymous]

@Manick1012  - 

You can create a new measure like the following:

(Note: the MAX function could be substituted with some other aggregate)

Value = 
IF(
    ISFILTERED(YourTable[YourFilterValue]),
    MAX(YourTable[ColumnA]),
    MAX(YourTable[ColumnB])
)

alternatively, you could have a single measure associated with each column, like this:

Value A= 
IF(
    ISFILTERED(YourTable[YourFilterValue]),
    MAX(YourTable[ColumnA]),
    BLANK()
)

Value B = 
IF(
    ISFILTERED(YourTable[YourFilterValue]),
    BLANK(),
    MAX(YourTable[ColumnB])
)

I hope this helps. If it does, please Mark as a solution.
I also appreciate Kudos.

[Manick1012]

Thanks for the suggestion - but that doesn't work.

[Anonymous]

@Manick1012  - Could you share a screenshot of the table, measure text, result, and expected result. It may be more beneficial to share the pbix, as well.

Thanks,

Nathan