Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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
Try using ALLEXCEPT function....
Measure = CALCULATE ( COUNT ( TableName[Orders] ), ALLEXCEPT ( TableName, TableName[Date] ) )
when I select other slicers the count is getting reduced....
Could you share your file or more details?
Can I have ur email or skype Id ?
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |