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 ar...
Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    abloor try this measure

     

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

     

parry2k's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

abloor Anna, yes it can be done using ISFILTERED or ISINSCOPE DAX functions. If you can share pbix file with sample data ( remove sensitive info before sharing), I can get you the solution.

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

      Sorry I just created generic sample data for the files uploaded and thought the column would be obvious - oops clearly not!

       

      It's the TotalShare% column in my sample that is summing in the subtotal row, and I don't want it to. (In my real file the column that I'm having the issue with is a stand alone column like this one and doesn't link to or feed off any other columns, just like in my sample file.)

       

      Thanks!

      • parry2k's avatar
        parry2k
        Icon for Super User rankSuper User
        6 years ago

        abloor try this measure

         

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