Forum Discussion
FILTERS-DAX AND DEFAULTING
Is there any way in DAX to identify were a Dimension Filter has been place in the Pivot Frame? The Issue is I am Trying to "Default" a Filter Selection Via Dax . ie You have a Filter True/False. ...
The Problem with This Approach, is that you cannot tell if the user has selected both Values (because teh Filter is in the Pivot frame showing "ALL") Or Not Selected either (because the Filter is not even in the Pivot Frame.)
It is Componded by Slicers Because there is No Difference in the Filter Between a Slicer Withall Members Selected and slicer With No Members Selected.
The Closest I Got was to Create the the 3 Member Slicer "True", "False", and "Both True and False"
But this still does not get aroundthe problem that we have a confusing Stituation that if the Dim is in the Filter Frame with No Selection it will Indicate "All" and the Total will be Will be a Subset.
Hi David,
Do you need the filter box to show ?
The slicer approach should address your aim
"I want my Pivot Table to show True Data UNLESS the User Explicity Selects False."
Do you need the filter box to show ?
The slicer approach should address your aim
"I want my Pivot Table to show True Data UNLESS the User Explicity Selects False."