Forum Discussion

Copper Contributor

Jul 14, 2017

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. ...

BI & Data Analytics

tips and tricks

Wyn Hopkins

MVP

Jul 15, 2017

David,

Could you put a slicer in conjunction with IF HASONEFILTER

Measure1

=IF (
    HASONEFILTER ( [Boolean] ),
    SUM ( [Cost] ),
    CALCULATE ( SUM ( [Cost] ), Data[Boolean] = True )
)

SergeiBaklan

Diamond Contributor

Jul 15, 2017

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.