Forum Discussion

Digger's avatar
Digger
Icon for Post Patron rankPost Patron
4 years ago
Solved

Wrong price different

Trying to find differnet between prices but PBI sum except of minus   Payments = SUMX ( SUMMARIZE ( Table, Table[_Eur_Pay],Table[id], Table[type] ), CALCULATE(MAX(Table[_Eur_Pay])) ) ...
Need Help
Show and Tell
Tips and Tricks
  • Pragati11's avatar
    Pragati11
    4 years ago

    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:

    • 1st table - all columns in summarised statement of 1st DAX and the measure
    • 2nd table - all columns in summarised statement of 2nd DAX and the measure

    Thanks,

    Pragati

     

Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
4 years ago

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:

  • 1st table - all columns in summarised statement of 1st DAX and the measure
  • 2nd table - all columns in summarised statement of 2nd DAX and the measure

Thanks,

Pragati

 

Digger's avatar
Digger
Icon for Post Patron rankPost Patron
4 years ago

please delete screenshot, as it has sensitivity info, ty

  • Pragati11's avatar
    Pragati11
    Icon for Super User rankSuper User
    4 years ago

    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