Forum Discussion

rpinxt's avatar
rpinxt
Solution Sage
3 years ago

Subtotal problems

Quick questions as I keep running into this.

 

When using a matrix I want to no show subtotals for every line (as that field is unique so it makes no sense!) but I do want to see the grandtotal.

 

Somehowe if I switch off row subtotals I also have no grand totals....

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi rpinxt ,

    Please try:

     

    Measure 2 = IF(ISINSCOPE('Table'[Column1])<>ISINSCOPE('Table'[Column2]),BLANK(),[Measure])

     

    Or:

     

    Measure 3 = IF(ISINSCOPE('Table'[Column1])<>ISINSCOPE('Table'[Column2]),BLANK(),SUMX(SUMMARIZE('Table','Table'[Column1],'Table'[Column2]),[Measure]))

     

    Result:

    The PBIX file is attached for reference.

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly -- How to provide sample data

    • rpinxt's avatar
      rpinxt
      Solution Sage
      3 years ago

      Ok thanks Anonymous 

      But if I'm correct then you only can do this with a measure?
      And then you will always have a blank row?

      Or is that only here because you also have the measure with subtotal in and maybe stepped layout on.

       

      So there is no settings option like in excel where subtotals and grand totals are seperately from eachother to control?