topic total value be shown only in DAX Commands and Tips

total value be shown only

razieh1990 — Fri, 06 Oct 2023 23:31:11 GMT

Hello

I created a matrix whose column is cities (A, B, C,) and the rows are the list of stations ( AA, BB, CC), and the value is the sale amount per city and station.

I want to add another value: the total sale quantity per station for all cities in the matrix.

so the matrix looks like this visualized below:

What I want :

I want to show the sale Amount per city and satation but I want to only display the total sale quantity per station and all cities instead of sale quantity per city and station .

below matrix I want to create , and need your advise how to create it in power bi:

Re: total value be shown only

tamerj1 — Sat, 07 Oct 2023 05:48:46 GMT

Hi razieh1990
You may utilize the "Total" to display the quantity

Re: total value be shown only

razieh1990 — Mon, 09 Oct 2023 14:59:13 GMT

Hello tamerj1

Thanks for your solution.

Is it possible to modify the solution you provided and calculate not only sum(sale quantity) but also sum ( sale amount) when it is not in the scope of city as total?

I mean now we have one column as total quantity at the end of matrix but I want to add total amount as well.

Do you think it is possible?

Re: total value be shown only

tamerj1 — Wed, 11 Oct 2023 06:56:46 GMT

razieh1990
You need to look into the table transformation detials inside the Power Query editor in the attached sample file.

Re: total value be shown only

razieh1990 — Wed, 11 Oct 2023 13:39:36 GMT

Thank you very much