Remove Total in Table for a Single Measure

[petrosk]

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?

[Phil_Seamark]

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]

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