Forum Discussion

Satz27's avatar
Satz27
Frequent Visitor
5 years ago
Solved

measures with filter slicer month [Need Help]

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 ...
Need Help
Show and Tell
Tutorial Requests
  • moizsherwani's avatar
    moizsherwani
    5 years ago

    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

     

     

moizsherwani's avatar
moizsherwani
Icon for Continued Contributor rankContinued Contributor
5 years ago

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