total value be shown only

[razieh1990]

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:

[tamerj1 · Accepted solution]

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

[tamerj1 · Accepted solution]

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

[razieh1990]

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? 

[tamerj1 · Accepted solution]

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

[razieh1990]

Thank you very much