Forum Discussion
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...
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
Thank you so much! That helps point me in the right direction and makes sense. I will share a pbix or dummy data next time, thank you.