Forum Discussion
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...
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] )
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
Anonymous
Change the date slicer to view it 'Between' or 'relative dates'