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

     

aj1973's avatar
aj1973
Community Champion
6 years ago

Hi Anonymous 

In your date Table create a Column for the workdays 

WorkingDay_Mark =
VAR WeekDayNum =
WEEKDAY ( DimDate[Date] )
RETURN
(
IF ( WeekDayNum = 1 || WeekDayNum = 7 ,0,1)
)
the use a slicer for the dates and a Card for your weekdays
Regards
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    thank you, all!

    but my main question is how to get the correct total number of days between jan and jun if no dates are selected in my filter

     

     

    Thank you!
    Sarah

    • aj1973's avatar
      aj1973
      Community Champion
      6 years ago

      Anonymous 

      Change the date slicer to view it 'Between' or 'relative dates'