Forum Discussion

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

Tips and Tricks

Tutorial Requests

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

Icon for Community Champion rank

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

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
Community Champion
6 years ago
Anonymous
Change the date slicer to view it 'Between' or 'relative dates'

Related content