Forum Discussion

andreaturri27's avatar
andreaturri27
Helper I
3 years ago
Solved

Delta calculation matrix measure

Hi community,    i have this situation.   I want to calculate yellow column. All column are Measure.  Marginalità=  JBilancioRiclass (2)'[Ricavi SIM]+'JBilancioRiclass (2)'[Costi Var Excel] + ...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    andreaturri27 , if all are measure you have to create a measure

     

    Marginalità= 
    'JBilancioRiclass (2)'[Ricavi SIM]+'JBilancioRiclass (2)'[Costi Var Excel] + 'JBilancioRiclass (2)'[Costi fissi EXCEL] + [Costo MP SIM] - 'JBilancioRiclass (2)'[Ammortamento misura] +[Magazzino misura]

     

    or

     

    Marginalità= 
    sumx('JBilancioRiclass (2)',  'JBilancioRiclass (2)'[Ricavi SIM]+'JBilancioRiclass (2)'[Costi Var Excel] + 'JBilancioRiclass (2)'[Costi fissi EXCEL] + [Costo MP SIM] - 'JBilancioRiclass (2)'[Ammortamento misura] +[Magazzino misura] )

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi andreaturri27,

Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.

If these also don't help, please share more detailed information to help us clarify your scenario to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng