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
amitchandak's avatar
amitchandak
Super User
6 years ago

TadeAde2020 , There a few ways. You can use slicers and visual or page level filter

 

You can use the filter in calculate of X functions

In calculate

Calculate(count(A[B]), A[payment]="Yes", filter2, filter3)

All these filter are and

Calculate(count(A[B]), filter(A, A[payment]="Yes" && A[Mode] = "ABC")

 

Here you can use && (and) || (Or), the tables should be joined which you are using

 

If they are not joined, refer

https://docs.microsoft.com/en-us/dax/treatas-function