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.
Trying to find differnet between prices but PBI sum except of minus
Solved! Go to Solution.
Hi @Digger ,
Thank you for the screenshot.
If I see your screenshot, you are showing this metrics at type level.
While you 2nd DAX is summarised and calculated at different set of columns. I think this might be causing the issue here.
Have you tried checking your measures independently, whether they are calculated correctly when summarised at relevant columns.
Try creating 2 tables:
Thanks,
Pragati
Hi @Digger ,
Just looking at your 2 DAX expressions, both expreassions are summarising the value at different granularities.
Can you share a complete screenshot please?
Thanks,
Pragati
Hi @Digger ,
Thank you for the screenshot.
If I see your screenshot, you are showing this metrics at type level.
While you 2nd DAX is summarised and calculated at different set of columns. I think this might be causing the issue here.
Have you tried checking your measures independently, whether they are calculated correctly when summarised at relevant columns.
Try creating 2 tables:
Thanks,
Pragati
please delete screenshot, as it has sensitivity info, ty
Hi @Digger ,
I have deleted the screenshot as I was unaware of it as you shared it as well.
Make sure from next time not to share any sensitive information. 🙂
Thanks,
Pragati
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 | |
101 | |
76 | |
64 | |
63 |
User | Count |
---|---|
141 | |
105 | |
101 | |
80 | |
67 |