Calculate total row in table with detail

[BAT]

Hello Power BI Community,

I'm new in Power BI.

I want to calculate the data for the Inventory column. For the regular rows, the data is taken from the data source, but the Powder All row is the sum of the rows above. Is there a way to calculate that row?

I try to use DAX but can only get regular row, not Power All row.

Data here

Thank you guy all

[Anonymous]

Hi @BAT ,

I don't quite understand what you mean, could you please use examples to show what the data looks like now and what you want it to look like?

Best regards,

Mengmeng Li

[TomasAndersson]

Hi, welcome!
The simplest solution for you would be use a matrix visual and add Pro Type, Brand and Format to Rows and the other columns to values.

That way you would get a table similar to an Excel pivot table that you can customize to make it show what you want.

Try it out and let me know if you need any more help.

[lbendlin]

Duplicating the same data in the same visual is a design red flag.  Don't do that.