Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |