Forum Discussion
Helper Itotal value be shown only
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:
Hi razieh1990
You may utilize the "Total" to display the quantityrazieh1990
You need to look into the table transformation detials inside the Power Query editor in the attached sample file.
4 Replies
- tamerj1
Community Champion
Hi razieh1990
You may utilize the "Total" to display the quantity
razieh1990Hello 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
razieh1990
You need to look into the table transformation detials inside the Power Query editor in the attached sample file.