Forum Discussion

petrosk's avatar
petrosk
Frequent Visitor
9 years ago

Remove Total in Table for a Single Measure

I have a table visualization with a few measures. The table includes totals, which I would like to keep for some of the measures, but not for others. Is there a way to selectively remove certain measures from being included in the totals row?

Need Help

2 Replies

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee
    9 years ago

    This can be achieved with a combination of the IF statement and some of the Filter functions.  It's reasonably straightforward but would help if you share a small set of data so we can build some examples for you?

    • ydaoud's avatar
      ydaoud
      Frequent Visitor
      8 years ago

      Hello Phil,

      I need some help, please.

       

      Here you can see a picture of the phone activity in power bi that should be turned into the same pic in Excel.

       

      I have to remove the total for Average Handling Time, for AHT_Format and for %age of answered call, %age of abandoned calls.

      How can I also keep the 2 columns and add only one column header for example for AHT and AHT_Format ==> 2 columns and the name is Average Handling Time.

       

      PS: I am using a live connection from my cubes.

      Thanks is advance