Forum Discussion

clubspec's avatar
clubspec
Helper III
6 years ago
Solved

Simple GP display on Matrix

Hi Guru,   I have tried many different ways trying to build a simple PL with Gross Profit on a matrix but no success.  I tried using SWITCH measure to nominate the measures displaying on the matrix...
Need Help
  • dax's avatar
    dax
    6 years ago

    Hi clubspec , 

    You could try below measure to get minus value.

    group mins = if(HASONEVALUE('Table'[GroupB]),CALCULATE(SUM(GL[Amount]), FILTER(GL,GL[GL]=RELATED('Table'[GL]))), CALCULATE(SUM(GL[Amount]), FILTER(GL,GL[GL]=RELATED('Table'[GL])&& RELATED('Table'[GroupB])="R"))-CALCULATE(SUM(GL[Amount]), FILTER(GL,GL[GL]=RELATED('Table'[GL])&& RELATED('Table'[GroupB])="E")))

     

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

dax's avatar
dax
Community Support
6 years ago

Hi clubspec , 

I am not sure whether you could change your Map table, I change your Map Table(delete total rows), then create relationship between GL and it. Then you could use Matrix  to achieve this goal. You could refer to my sample for details.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

clubspec's avatar
clubspec
Helper III
6 years ago

Hi dax Zoe,

That is not right because the GP is Total Rev minus Total Exp.  What you did is to sum them all.

And the Description (Desp) must exactly per the map, that's why I used measures to calculate the Total Rev, Total Exp, and GP.  And then use SWITCH to nominate which measures I wanna show.

  • dax's avatar
    dax
    Community Support
    6 years ago

    Hi clubspec , 

    You could try below measure to get minus value.

    group mins = if(HASONEVALUE('Table'[GroupB]),CALCULATE(SUM(GL[Amount]), FILTER(GL,GL[GL]=RELATED('Table'[GL]))), CALCULATE(SUM(GL[Amount]), FILTER(GL,GL[GL]=RELATED('Table'[GL])&& RELATED('Table'[GroupB])="R"))-CALCULATE(SUM(GL[Amount]), FILTER(GL,GL[GL]=RELATED('Table'[GL])&& RELATED('Table'[GroupB])="E")))

     

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.