Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Measure not displaying full amount

Hi,   I am trying to display the number of weekdays for each month but the selecting filter is not working In the screenshot below, when I select Apr, it correctly shows the April numbers, but whe...
General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    Hi Anonymous ,

     

    You could create a measure to get the slicer status. If the result returns blank, you could make it return the sum of all months.

    Measure =
VAR a =
    SELECTEDVALUE ( 'Slicer'[Month] )
RETURN
    IF (
        ISBLANK ( a ),
        SUMX ( ALLSELECTED ( 'Table'[Month] ), [Count Weekday Official] ),
        [Count Weekday Official]
    )

     

v-eachen-msft's avatar
v-eachen-msft
Community Support
6 years ago

Hi Anonymous ,

 

You could create a measure to get the slicer status. If the result returns blank, you could make it return the sum of all months.

Measure =
VAR a =
    SELECTEDVALUE ( 'Slicer'[Month] )
RETURN
    IF (
        ISBLANK ( a ),
        SUMX ( ALLSELECTED ( 'Table'[Month] ), [Count Weekday Official] ),
        [Count Weekday Official]
    )