ignore all slicers except date slicer

[Sandeep641]

I have multiple slicers which will give count of orders.. I would like to ignore all slicers and include only date slicer and give the count... how can I do that ,, Please help

[v-shex-msft]

Hi @Sandeep641,

You can try to use all function to break filter effect.

For example:

Count =
CALCULATE ( COUNT ( table[Column] ), ALL ( table ) )

Regards,
Xiaoxin Sheng

[Zubair_Muhammad]

@Sandeep641

Try using ALLEXCEPT function....

Measure =
CALCULATE (
    COUNT ( TableName[Orders] ),
    ALLEXCEPT ( TableName, TableName[Date] )
)

[Sandeep641]

when I select other slicers the count is getting reduced....

[Zubair_Muhammad]

@Sandeep641

Could you share your file or more details?

[Sandeep641]

Can I have ur email or skype Id ?