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.
Hi,
I have a requirement seats table which includes columns as location and seats
Location | Seats |
Hyderabad | 1000 |
Chennai | 2000 |
Mumbai | 3000 |
and utilization table which includes columns as location and percentage utilization
Location | Utilization perc |
Hyderabad | 0.75 |
chennai | 0.62 |
Mumbai | 0.79 |
I have common dimension of city which includes columns city
CITY
Hyderbad
Bangalore
Mumbai
Relationship between tables seat to city dimension and city to utilization tables
Need to calculate irrespective of the city against (utilization perc) *( seats)
1000 * 0.75 = 750
2000*0.62 = 1240
3000*0.79 = 2370
dax should return 750+1240 +2370 = 4360.
Note : i dont have city slicer.
Please help
Solved! Go to Solution.
Hi, @MJALARI
I am not sure if I understood your question correctly, especially the part that you do not have a city slicer.
However, please check the below picture and the sample pbix file's link down below.
It is for creating a measure, not a column.
Expected Result Measure =
SUMX ( Seats, Seats[Seats ] * RELATED ( Utilization[Utilization perc] ) )
https://www.dropbox.com/s/vjf2ucs7tjhzjac/mjalari.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi, @MJALARI
Thank you for your feedback.
Please check the below.
Expected Result Measure =
SUMX (
Seats,
Seats[Seats ]
* LOOKUPVALUE (
Utilization[Utilization perc],
Utilization[Location], RELATED ( Cities[City] )
)
)
https://www.dropbox.com/s/vjf2ucs7tjhzjac/mjalari.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi Jihwan ,
i dont have direct relationship between two tables , i have city dimension as intermediate. Apologies, missed to update
Hi, @MJALARI
I am not sure if I understood your question correctly, especially the part that you do not have a city slicer.
However, please check the below picture and the sample pbix file's link down below.
It is for creating a measure, not a column.
Expected Result Measure =
SUMX ( Seats, Seats[Seats ] * RELATED ( Utilization[Utilization perc] ) )
https://www.dropbox.com/s/vjf2ucs7tjhzjac/mjalari.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |