How to know if the user selected something on a slicer?

[Anonymous]

Hello everyone, 

I have a slicer on my report and a gauge that is filtered according to the selected value on the slicer. However if nothing is selected on the slicer then the value in the gauge correspodns to the first value on the slicer. I have a measure:

SelectedValue = FIRSTNONBLANK(Table[Column], Table[Column])

With this I get the selected value from the slicer. What I want is the following, if I don't select anything then the value on the gauge would be calculated for all the data. Here is an example

I want this measure to be calculated for both option 1 and option 2 if i have neither option selected. How can I do that? Any advice is welcomed.

Thanks 🙂

[v-shex-msft]

Hi @Anonymous,

>>I want this measure to be calculated for both option 1 and option 2 if i have neither option selected. 

You can try to use below formula:

Measure:

CalculatWithSlicer= Calculate(expression,AllSelect(Table[Column]))

Sample:

SumOfSlicer= Calculate(Sum(Table[Amount]),AllSelect(Table[Column]))

AvgOfSlicer= Calculate(Average(Table[Amount]),AllSelect(Table[Column]))

Regards,

Xiaoxin SHeng

[Anonymous · Accepted solution]

Thanks @v-shex-msft, but I used the ISFILTERED() function to see if I have anything selected on the slicer.