Forum Discussion
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 selection of this, and store in a variable (ignoring other slicers). I then need to show a count of rows based on other slicer selections, ignoring the date slicer. The end goal is to then calculate the percentage of rows based on the other slicers, of the total rows based on the date slicer. I hope this makes sense and thank you for any suggestions. 🙂
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
2 Replies
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.
