Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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:
Solved! Go to Solution.
@razieh1990
You need to look into the table transformation detials inside the Power Query editor in the attached sample file.
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?
@razieh1990
You need to look into the table transformation detials inside the Power Query editor in the attached sample file.
Thank you very much
User | Count |
---|---|
50 | |
24 | |
18 | |
17 | |
14 |
User | Count |
---|---|
91 | |
86 | |
39 | |
25 | |
21 |