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.
I am working on a BI project where I will be reporting a score card againsted a test people take. There are multiple sections per test called "Phases". Each Phase has about 10 - 20 Yes\No questions. I created the following measure to get a score
Score = DIVIDE([Count Yes],[Count Asked]-[Count N/A])
I have one table of all the answeres and another lookup table of the different phases.
If I pick Phase and Score on a table the value is correct score per Phase.
My challange, is that I am tring to build a "Test" question HTML view that shows all the questions and answers with the HTML Content visualization but I would like the left side to be a slicer that shows the Phase + the Score for that test. That way a manager could look quickly at the slicer and see the section someone did poorly on and click that same slicer to quickly filter to those questions. I have this working fine If I just use Phase but I create a calculated column, it's returning the overal Score for all tests and not just the current test selected.
@NickTT It will be easier if you provide some sample data and expected output.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
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 |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
107 | |
105 | |
87 | |
61 |