Forum Discussion

abloor's avatar
abloor
Icon for Helper IV rankHelper IV
6 years ago
Solved

Stop % from summing in subtotal row

Hi, Can anyone please suggest how to stop a % measure from adding up in a subtotal row?  I want the subtotal row there, but want it to be blank for the List % and Var % columns as pictured, s they are values which can't be summarized.  I'm happy for the Share % subtotal to remain.

 

**Default Summarization is set to 'Don't Summarize'**

 

 

 

 

I think the problem is stemming from the source data.  I'm linking to an excel file where there is a percentage in the cell. (I'm not acually doing the maths of dividing one value by another to get a percent. There's no way around this.)

 

Any ideas?

 

Thanks in advance!

 

Anna.

Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    abloor try this measure

     

    TotalShare% = 
IF ( 
ISFILTERED( Table1[Colour] ), 
CALCULATE(SUMX('Table1','Table1'[Share %])) 
)

     

8 Replies