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]
    )

     

nvprasad's avatar
nvprasad
Icon for Solution Sage rankSolution Sage
6 years ago

Hi,

 

Can you try below measure to calculate count of week days?

 

Weekday_Check =
CALCULATE (
COUNTROWS ( 'Table' ),
FILTER ( ALL ( 'Table'[Date] ), WEEKDAY ( 'Table'[Date], 2 ) < 6 )
)

 

Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂

Regards,
N V Durga Prasad