PowerBI customize totals in table

[Anonymous]

Hi all,

I want to have two different totals in one table as below ( Total Yield and Total Product Tons), please assist on how to go about this.

Regards

Lufuno

[v-shex-msft · Accepted solution]

HI @Anonymous,

You can create a new calculated table to extract category field values and new total rows, then you can create a visual with new table fields and write measure formula to return correspond results based on the current category.

Category Table =
UNION ( VALUE ( Table[Column] ), { "Total1", "Total2" } )

Measure =
SWITCH (
    SELECTEDVALUE ( 'Category Table'[Column] ),
    "Total1", 'formula',
    "Total2", 'formula',
    'common formula'
)

Regards,

Xiaoxin Sheng

[AiolosZhao]

Hi @Anonymous ,

You may need to try to add one more level for your dimension.

For example, now what you have is :

Category

SSCC Yield

MET Yield

PSC Yield

SSCC Product Tons

MET Product Tons

PSC Product Tons

Please try to add a mapping like below:

NEW LEVEL	Category
Total Yield	SSCC Yield
Total Yield	MET Yield
Total Yield	PSC Yield
Total Product Tons	SSCC Product Tons
Total Product Tons	MET Product Tons
Total Product Tons	PSC Product Tons

Then put these two columns into table and using  +/- icons, then I think you can see the subtotal as you want in your table.

Aiolos Zhao