Forum Discussion
smileamile2
1 year agoResolver I
Slicer DAX
Error
- 1 year ago
Solution implemented was using default functionality of the new slicer visual.
smileamile2
1 year agoResolver I
x
danextian
1 year agoSuper User
hI smileamile2
Include an additional condition to check if the count of the selected values matches the total count when no selection is made. Try this:
Filter =
VAR _VALUES =
UNION ( VALUES ( StatusOrState[Value] ), { BLANK () } )
VAR _VALUES2 =
VALUES ( StatusOrState[Value] )
VAR _ALL_SELECTED_TEST = COUNTROWS(ALL(StatusOrState)) = COUNTROWS(StatusOrState)
RETURN
IF (
NOT ( ISFILTERED ( StatusOrState[Value] ) ) || _ALL_SELECTED_TEST,
CALCULATE (
COUNTROWS ( 'Table' ),
KEEPFILTERS ( 'Table'[Status] IN _VALUES || 'Table'[State] IN _VALUES )
),
CALCULATE (
COUNTROWS ( 'Table' ),
KEEPFILTERS ( 'Table'[Status] IN _VALUES2 || 'Table'[State] IN _VALUES2 )
)
)