Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Dear All,
Could you please assist me with the below problem ?
I have sales data that contains the date of transaction, country of transaction, like below:
ID - Country - Sold Total
ABC1 - DE - 3
ABC2 - PO - 2
ABC3 - FR - 9
ABC4 - US - 8
ABC - MX - 7
ABC - PE - 6
.
.
.
This data should be summed and compared to a Budget, the problem is that the Budget can be either a country or a continent.
For example, we have a budget for US only , totalizing 890 sold units and a Budget for Europe (Including DE , PL and FR, all other countries have their own Budget), as below:
Region - Budget
US - 990
NL - 540
SP - 320
EU - 480
The approach I made was to create a new table containing the country and the Budget Region they belong to, therefore as below
Sold Country - Region
US - US
NL - NL
MX - MX
DE - EU
PL - EU
FR - EU
My thought was, if I create a realationship from the sales data Country with this new table sold country, I would be able to include all resuslts from DE,PO,FR in the region EU, but it is not working
The Matrix in Power Bi show as:
Region - Sold Unit
"Blank" - 480
US - 990
NL - 540
SP - 320
EU - 480
So it does not work with EU. Would anyone know the reason why?
It's not working because you don't have a country level budget. You cannot show DE , PL, and FR sales sparately, you can only show EU sales because that's what your budget granularity is.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
98 | |
75 | |
63 | |
62 |
User | Count |
---|---|
135 | |
105 | |
104 | |
80 | |
65 |