Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
This is how my base table data looks like
I needed to add an additonal column "Status" here which worked on a if statement. If (Pass=Total, 'Passed", "failed") and was successful in doing that. Here is howit looked like.
Now I again have to build a summary table based on the status column and the Catefory to show how many subcategories have passed or failed. Please help. Ideally the table would look like below:
Solved! Go to Solution.
Hi @naveenvs ,
Select Count
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
Hi @naveenvs ,
Use this as a Visualization in matrix .
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
Thanks for the reply. When I do that I still get the sum, but I am looking for the Count (which is the selection).
I assume it is because of the way I am caluckating status. This is what I get
Hi @naveenvs ,
Select Count
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
@naveenvs - Did you check the aggregation on the column in your Values area (drop down arrow) and make sure it is set to Count. Or is this a measure?
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |