Problem With Using Countx in DAX

mouzi4us

New member
Joined
Dec 13, 2015
Messages
2
Reaction score
0
Points
0
Excel Version(s)
2019
Hello friends,

I have created a data model in excel and trying to calculate the distinct count of customers in my model.
What I want is not just a simple distinct count. I want to count the customers with the positive sales Qty.

I have found a way to create a measure which works fine in calculating the desired answer. But I want to have another measure to calculate the "number of active customers in Category" in case that I have the products in my pivot table.

I will attach my data model for you in case you need to check my model.

I used this formula to calculate the Active customers with positive sales qty: "COUNTX(FILTER(ALLSELECTED(Table1[Customer Id]),Table1[Sum of Qty]>0),[Sum of Qty])"

I will be so thankful if you guys could help me in using dax "All" or whatever needed function in my measure to solve my problem
Sample.jpgcalc.jpg
 

Attachments

  • Data Model Sample.xlsx
    164 KB · Views: 7
Back
Top