Forum Discussion

bilaali's avatar
bilaali
Frequent Visitor
3 years ago

Calculation Group - Gross Margin %

Hello, Wondering if anyone can help me with a calculation group discrepancy, I’m encountering with formulating Gross Margin % when utilizing Variance and % Change The Gross Margin % within Ta...
Need Help
bilaali's avatar
bilaali
Frequent Visitor
3 years ago

Hello JirkaZ,

Thank you for your prompt response.

 

The Actuals & Actuals PY are measures

Actuals = SUM ( 'GL Actuals'[Amount] )
Actuals PY = CALCULATE ( 'GL Actuals'[Actuals], SAMEPERIODLASTYEAR ( 'Calendar'[Date] ) )

 

JirkaZ's avatar
JirkaZ
Icon for Solution Specialist rankSolution Specialist
3 years ago

Ok - got it. But the standalone measures when put into the matrix visual do work, correct?

  • bilaali's avatar
    bilaali
    Frequent Visitor
    3 years ago

    Hello JirkaZ,

     

    Yes, the standalone measures work, but when combined with the Calculation Groups of Gross Margin % the Variance and % Change don't work correctly.