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 All,
Could anyone help me solve below business scenarions?
Distribution Point Definition: One product sold to one customer with real purchasing value amonnt ( we might send customer samples for free and this of couse won't be calculated as DPs) called One DP.
I need to use a DAX to do this calculation.
I tried to use DISTINCTCOUNT Function, but it could only tell me how many products are sold per month, or how many customers we have per month. I need sort of combing them altogether.
I could do this in Excel using Countif as below (1) and came out the DPs as (2)
On below tables (3) is customer name and (4) is products purchased by this customer.
We might want to know how many DPs we are having per month or per quarter.
Really Appreciate if anyone could solve me this puzzle.
Thanks,
Peter Sun
If you can post some sample raw data I can be more specific. Otherwise, the general replacement for COUNTIF in DAX is CALCULATE like so:
Measure = CALCULATE(COUNT([Column]),FILTER(Table,[Column/Measure] > 0))
Something along those lines.
Thanks for your quick reply
And please see below raw data and it is quite falt comparing with pivot table.
If only used below calculated measure, it would only get the how many products are sold, right?
Can you please help me? Thanks
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |