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 meas...
Need Help
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