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,
For a single month, I can calculate the distinct count of customers with positive volume with the following measure:
Solved! Go to Solution.
@Anonymous , Try like
Dist Qtr =
CALCULATE (
countx(filter(values ( Facts[Customer CompKey] ),calculate(sum(Facts[Quantity (L)])) > 0),[Customer CompKey]),
//This needs done at the aggregate level i.e. SUM(Facts[Quantity (L)]) > 0
ALL(Period),
DATESINPERIOD ( Period[Calendar Date].[Date], LASTDATE ( Period[Calendar Date] ), -3, MONTH )
)
Hi @Anonymous
Could you show me your data model? Please share a sample with me by your Onedrive for Business. And you can show me the result want. This will make it easier for me to understand your requirement.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , Try like
Dist Qtr =
CALCULATE (
countx(filter(values ( Facts[Customer CompKey] ),calculate(sum(Facts[Quantity (L)])) > 0),[Customer CompKey]),
//This needs done at the aggregate level i.e. SUM(Facts[Quantity (L)]) > 0
ALL(Period),
DATESINPERIOD ( Period[Calendar Date].[Date], LASTDATE ( Period[Calendar Date] ), -3, MONTH )
)
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 |
---|---|
108 | |
98 | |
81 | |
65 | |
62 |
User | Count |
---|---|
147 | |
116 | |
104 | |
88 | |
65 |