Forum Discussion

SarahESkells's avatar
SarahESkells
Icon for Helper I rankHelper I
4 years ago
Solved

Matrix subtotals show wrong percentage

Hi, I have a matrix that pulls across a % column. However when I add an additional field into the Rows (to create subgroups) the %'s are summed rather than worked out as a % of the sub-totals and I'm...
Need Help
  • David-Ganor's avatar
    David-Ganor
    4 years ago

    Hi SarahESkells ,

     

    Please create the following measure:

     

    ACT/FOR = SUM('Table'[ACTUAL])/SUM('Table'[FORECAST])
     
    Hope it helps,
    David Ganor
David-Ganor's avatar
David-Ganor
Icon for Resolver II rankResolver II
4 years ago

Hi SarahESkells ,

 

Please create the following measure:

 

ACT/FOR = SUM('Table'[ACTUAL])/SUM('Table'[FORECAST])
 
Hope it helps,
David Ganor
SarahESkells's avatar
SarahESkells
Icon for Helper I rankHelper I
4 years ago

Amazing, thank you