Forum Discussion

TadeAde2020's avatar
TadeAde2020
New Member
6 years ago

Count Multiple conditions: DAX

Hi, this my first post in this forum. I have been searching for a solution all day but no luck. Below is my question - On a table I have a column called 'sector' that categorises customers to the se...
Need Help
edhans's avatar
edhans
Community Champion
6 years ago

A table/sample data would be helpful. But the below pseudo code would be how I would approach it with the limited knowledge of what you have:

Total Count =
COUNTX(
    FILTER(
        Sometable,
        sometable[field1] = "this"
            && sometable[field2] = "that"
    ),
    sometable[field1]
)

 

&& does AND. You can just keep adding other conditions. 

Change it to || if you want it to be an OR comparison.

 

How to get good help fast. Help us help you.
How to Get Your Question Answered Quickly
How to provide sample data in the Power BI Forum