Forum Discussion

Meeshe's avatar
Meeshe
Frequent Visitor
2 years ago
Solved

DAX count all rows based on specific slicer selections

I'm trying to achieve row count based on the user slicer selections, but not all of them. I have multiple slicers, the main one is a date slicer, I need to show a count of all rows based on the selec...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Meeshe ,

According to your description, I think allexcept function should be suitable for your requirement, you can refer to the following blog to know more about the all function and its usage.

Managing “all” functions in DAX: ALL, ALLSELECTED, ALLNOBLANKROW, ALLEXCEPT - SQLBI

BTW, can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng