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
JirkaZ's avatar
JirkaZ
Icon for Solution Specialist rankSolution Specialist
3 years ago

I can see immediately that the _Actuals and Actuals_PY variables don't use any form of aggregation. At the same time I assume those are referencing a column (not a measure). 
So you have to implement some sort of aggregation (a SUM probably).

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.