Forum Discussion
How to fix range measure calculation
Done,
here is my solution
https://drive.google.com/drive/folders/1hzAYmnoNTT9-oEktmxwirq47gIqez9zF?usp=sharing
If this helped, please consider giving kudos and mark as a solution
me in replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
Thanks - it will be better if I attach an example 😁 - so
Measures calculate correctly only OPA levels summary - I want to have also correct ITM level summary (and Totals) based on OPA like :
Thanks a lot !!
https://drive.google.com/file/d/1hLcXEbaiyvjvBw_tajke4uschQUNVQz0/view?usp=sharing
V-yubandi-msftCommunity Support
Hello Bobass75 ,
Thanks for your feedback and clarification. I’ve tested this with a different sample dataset and updated the measures using SUMX. This ensures that not only the OPA level values are accurate, but also that the item Level subtotals and overall totals correctly reflect the sum of OPA level values, just as you mentioned.
Here’s what you’ll notice now.
-
Miara values are correctly grouped into <150k, 150-300, and >300buckets.
-
OPA level values are broken down accurately.
-
And most importantly item level and total rows now summarize based on those OPA level results, instead of recalculating from raw data.
Let me know if you'd like to review anything else or if further adjustments are needed.
Best regards,
YugandharHello
The idea is a bit different: calculating the sum (sales) of attributes other than OPA (opportunity) based on the sum of OPA. This means we first sum OPA, creating a range, and then assign the corresponding residual values of other attributes, such as ITM (item). (like in my example)
I'm struggling most with creating a measure that works without the OPA context in the table. It would be simpler to precalculate the sum/range of OPA in the table and assign a range ID to each row of the fact table, but this is supposed to work dynamically, so only DAX remains.I hope I explained my problem better 🙂 Thanks a lot !
- FBergamaschi
Super User
Can you please republish this picture
indicating what you want to see in each cell? The arrows you draw there are confusing me
-