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.
Good Day,
I have data like this:
I want to create a Matrix that shows the sum of the value. Formula:
Total Value = sum(Sheet1[Value])
My requirement is to have values from two diffent levels in the same row. Thus summing the Level1 - Colour, and only one of the Level2 - Square. As such:
But I can't get the formatting right. All I can get is this:
Can you please assist?
Thanks!
Solved! Go to Solution.
Thanks @prateekraina,
I understand the logic.
Next up I just have to create the custom table with queries and logic on my side.
Thanks so much!
Hi @DieLem,
Glad to know that it solved your problem.
It would be appreciated if you could hit thumbs up for my answer 🙂
Prateek Raina
try this
Total Value = VAR ProperFilter = FILTER ( Sheet1, Sheet1[Level1] <> "Shape" || Sheet1[Level2] = "Square" ) RETURN CALCULATE ( SUM ( Sheet1[Value] ), ProperFilter )
Hey @Stachu,
Thanks for the feedback. Your solution returns the correct value.
However that is not my main issue. How do I use the "Matrix" / "Table" visualisation to have Colour and Circle as the only two entries, directly underneath each other?
Thanks!
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 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |