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] )
amitchandak
Super User
Super UserAnonymous , you can create a workday column in date table and sum it up
Workday= if(WEEKDAY([Date],2)<6,1,0)