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,
We need to calculate the average number of weeks that are passed before 80% of the sales are reached. So first we need a calculation to get this measure per product (KMM_Name), then we need the average of that. We want this per product, but those have subproducts as well, these do not to be taken into account. The source is a tabular cube, so we are not able to create additional tables/columns. The tests we did are the following:
1) measure to calculate the cumulative sales %:
2) measure to calculate the number of weeks before 80% has been reached:
In the above picture we would expect 33. With 11 movies this would result in an average of 3. The 3 is our wanted end result.
I hope the explanation is clear enough to give us some tips.
Kind regards,
Lise
Solved! Go to Solution.
Hi @lbraeckman ,
Try the measure below:
sumx(values(Movies[KMM_Name]), [OLD - Avg Week GBO > 80%])
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
@lbraeckman , change this var and check
VAR cor = sumx(values(Movies[KMM_Name]), hasonev)
Thanks for the suggestion, but this gives me 0 as result
Hi @lbraeckman ,
Try the measure below:
sumx(values(Movies[KMM_Name]), [OLD - Avg Week GBO > 80%])
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Super, this solves it, 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 |
---|---|
97 | |
97 | |
82 | |
74 | |
66 |
User | Count |
---|---|
121 | |
105 | |
102 | |
82 | |
72 |