Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Everyone,
I need to calculate count/DistinctCount based on a condition.
For example in below table, when Type is "Agreement1", I should determine total count of "Customer" for "Agreement1".
When Type is Agreement2, I should determine distinct count of "Customer" for "Agreement2"
Partner | Customer | Type |
p1 | c1 | Agreement1 |
p1 | c2 | Agreement1 |
p2 | c1 | Agreement1 |
p2 | c3 | agreement2 |
p3 | c2 | agreement2 |
p4 | c3 | agreement2 |
p1 | c3 | agreement2 |
In the below case, I should get numbers like this
Agreement1 | agreement2 |
3 | 2 |
Can you please let me know how can we acheive this through single DAX measure.
NOTE: I even have date columns, so I should be able to slice it accordingly through dates
Thanks,
Raksha
Solved! Go to Solution.
Hi @raksharh ,
You can use the below measure:
Hi @raksharh ,
You can use the below measure:
Hi! If you just need those two measures let's see.
I think this should be enough.
Agreements1 =
CALCULATE (
COUNT(Table[Customer]),
Table[Type] = "Agreement1"
)
In the second case
Agreements2 =
CALCULATE (
DISTINCTCOUNT(Table[Customer]),
Table[Type] = "agreement2"
)
Hope this help,
Regards,
Happy to help!
User | Count |
---|---|
54 | |
23 | |
19 | |
18 | |
17 |
User | Count |
---|---|
91 | |
87 | |
47 | |
28 | |
22 |