Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have an unresolved case, I want to make measures if the selected month slicer is only 1 month using the sum formula, but if the selected one is more than 1 month then use the average formula. what formula does this use?
Solved! Go to Solution.
Hi there,
Does the following work for you?
SampleMeasure =
VAR SelectedMonth =
SELECTEDVALUE ( SampleData[Date] )
RETURN
IF (
NOT ( ISBLANK ( SelectedMonth ) ),
SUM ( SampleData[Val] ),
AVERAGE ( SampleData[Val] )
)
With one value selected
With more than one value selected
Hi there,
Does the following work for you?
SampleMeasure =
VAR SelectedMonth =
SELECTEDVALUE ( SampleData[Date] )
RETURN
IF (
NOT ( ISBLANK ( SelectedMonth ) ),
SUM ( SampleData[Val] ),
AVERAGE ( SampleData[Val] )
)
With one value selected
With more than one value selected
Thank you very helpful
User | Count |
---|---|
124 | |
106 | |
99 | |
63 | |
59 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |