Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 🙂
Solved! Go to Solution.
Thanks @v-shex-msft, but I used the ISFILTERED() function to see if I have anything selected on the slicer.
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
Thanks @v-shex-msft, but I used the ISFILTERED() function to see if I have anything selected on the slicer.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |