Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Experts,
Need your help to calculate distinct count of my customers by "Customer code" where SalesQty sum of basepack code "6A43B3A48TV170301" & "6A43B3A48TV170303" is equal or greater than 8. Condition is none of the basepack code alone should be less than 1.
Download the excel data: https://we.tl/t-RsXKbpVttv
TIA
Hi @mamunabdullah ,
Try this measure:
=
COUNTROWS (
FILTER (
'CustomerSales',
OR (
[Basepack Code] = "6A43B3A48TV170301",
[Basepack Code] = "6A43B3A48TV170303"
)
)
)
And put it in the filter pane of this table visual then set it show items which is equal or greater than 8
Pbix in the end you can refer.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @v-chenwuz-msft, maybe I couldn't make you understand my requirement. I need to check how many customers have purchased more than or equal 8 units of combined basepack "6A43B3A48TV170301" & "6A43B3A48TV170303". But each of the basepack purchase must not be less than 1.
Hi @ERD, I saw you solved similar problem! Can you pls help me out with this one?
Hello @mamunabdullah ,
Don't know if you still need some help, but you can try this measure:
YourMeasure =
VAR t_with_b_code =
CALCULATETABLE (
CustomerSales,
CustomerSales[Basepack Code] IN { "6A43B3A48TV170301", "6A43B3A48TV170303" }
)
VAR rows_amt = COUNTROWS ( t_with_b_code )
RETURN
SUMX ( FILTER ( t_with_b_code, rows_amt = 2 ), [SalesQty] )
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your Kudos.
Check out my latest demo report in the data story gallery.
Stand with Ukraine!
Here are official ways you can support Ukraine financially (accounts with multiple currencies):
1) Support the Armed Forces of Ukraine: https://bank.gov.ua/ua/about/support-the-armed-forces
2) Come Back Alive foundation: https://www.comebackalive.in.ua/
Thank you!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
36 | |
33 | |
18 | |
18 |