Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
101 | |
91 | |
83 | |
76 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |