Forum Discussion
FILTERS-DAX AND DEFAULTING
David,
Could you put a slicer in conjunction with IF HASONEFILTER
Measure1
=IF (
HASONEFILTER ( [Boolean] ),
SUM ( [Cost] ),
CALCULATE ( SUM ( [Cost] ), Data[Boolean] = True )
)
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."
Wyn,
I tried once that approach but it disturbs end users - they see the filter is not selected, however have the result for some "default" filter, not obvious which one.
Another point is to see results for not filtered data, additional set of measures is to be used.
However, in some scenarios that could work.
