The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Table Customer
Customer Key | Customer Type |
1 | L |
2 | S |
3 | L |
4 | S |
Sales Table
Sale Qty | Sale price | Customer ID |
50 | 2 | 1 |
20 | 5 | 2 |
10 | 10 | 3 |
100 | 30 | 4 |
200 | 8 | 3 |
I am trying to count distinct customers for a particular type who made sale using Filters (strictly not by calculate)
So far I came up with this :
FILTER ( Sales,
Related(Customer[CustomerType] = "L"
)
not sure who do I go from here.
Solved! Go to Solution.
Hi @ARK8
Please try
Count =
COUNTROWS (
SUMMARIZE (
FILTER ( Sales, RELATED ( Customer[CustomerType] ) = "L" ),
Customer[Customer Key]
)
)
Hi @ARK8
Please try
Count =
COUNTROWS (
SUMMARIZE (
FILTER ( Sales, RELATED ( Customer[CustomerType] ) = "L" ),
Customer[Customer Key]
)
)
User | Count |
---|---|
15 | |
8 | |
6 | |
6 | |
5 |
User | Count |
---|---|
25 | |
13 | |
12 | |
8 | |
8 |