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 all,
I've been playing with something that is likely quite simple but having difficult working out how to do it. I have two tables one consisting of names/items with a yes / no if they have the items. I have a second table that has a score. If the user has any of the item, I want it to provide a total score for each of the items.
For example using Jane:
Jane total = Car (5) + Bicycle (2) + Skateboard (0) + Garage (3) should return a total of 10 out of a total possible of 11 that I will add to a gauge. I hope the below is clear however I have attached the pbix here for review.
If anyone has some guidance of how I create the relationships (or skip this and just add each score in a measure), please let me know. I tried to create a measure but not sure to add up the if statements.
Many thanks
Solved! Go to Solution.
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.
@Jihwan_Kim This is brililant! Thank you.. didn't think to unpivot etc. Much appreciated although I will need to spend some time understanding the measure!
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 |
---|---|
111 | |
95 | |
77 | |
69 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |