Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi everyone!
Table 1:
Site | Theme | Score |
London | A | 2 |
London | A | 3 |
London | A | 2 |
London | B | 4 |
Paris | A | 3 |
Paris | A | 4 |
Paris | A | 1 |
Paris | B | 1 |
Table 2: Dim_ThemeMax
Theme | Max |
A | 15 |
B | 6 |
How do I create something in DAX to plot each site's score per theme as a % of theme max score, rather than just plot the raw scores per theme?
Many thanks!!
Solved! Go to Solution.
Hi, @jonnyko
I am not sure how your desired outcome looks like, but please check the link down below.
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, @jonnyko
I am not sure how your desired outcome looks like, but please check the link down below.
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.
thanks for the quick response Jihwan, it works on your file and data structure is identical to mine, but when I put it into my Power BI I think the denominator isn't quite pulling through the value per theme. It seems maybe that it's just a fixed value of the count of number of themes there are - there is a 1:many relationship between my Dim_theme table and table with the individual scores though based on Theme....
any thoughts?
Hi, @jonnyko
Thank you for your feedback.
Please share your sample pbix file's link here, then I can try to look into it to come up with a more accurate measure.
Thanks.
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.
just realised I went wrong by adding a sum( to the table score within my sum( already - your solution has worked. Thank you Jihwan!
User | Count |
---|---|
87 | |
72 | |
68 | |
64 | |
54 |
User | Count |
---|---|
98 | |
89 | |
74 | |
67 | |
62 |