I am using a dashboard that shows no.of students(distinct), school-wise(row) and test-wise(column) who have passed certain tests (out of total 5 tests) . We could see the dynamic measure for the no. of students(distinct)in the matrix based on the date slicer. However, I couldn't figure out how to show a dynamic measure in another matrix or a dynamic calculated column value against each student in the student table the no. of unique tests (0 to 5) he has passed for any selected duration of period(from date slicer).
A student may take the test any no. of times an the Table Test may contain the data beyond the selected dates in the slicer. The dynamic measure should only consider the data for the selected dates from the slicer.
I have 3 Tables connected with common columns as below:
Table School: SC_ID, SC_Name
Table Student: ST_ID, ST_Name, SC_ID
Table Test: ST_ID,Test_Name, Test_Date, Test Status
Thanks in advance.
Hi @Krish35 ,
Based on the information you provided, the description is somewhat complicated. Can you provide the expected results you expect, so that I can do further testing?
Looking forward to your reply.
Hi @Krish35 ,
Based on the information you provide, it may not be possible to fully reproduce the results you expect. But according to your needs, I have done the following tests, which can be used as a reference:
Count the students who passed, "pass" is set to 1
Create a matrix and place the created column in the value position. Put the date in the slicer.
By filtering the date, the results are displayed dynamically in the matrix.
If the established model is not correct, please provide detailed test data and information so that I can do accurate tests. Looking forward to your reply.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Check out new user group experience and if you are a leader please create your group
Click here to read more about the March 2021 Updates!
100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.
See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.