Forum Discussion

Krish35's avatar
Krish35
Frequent Visitor
5 years ago

Dynamic Calculation on date slicer

Hi 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 ...
Need Help
v-henryk-mstf's avatar
v-henryk-mstf
Community Support
5 years ago

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.


Best Regards,

Henry

  • Krish35's avatar
    Krish35
    Frequent Visitor
    5 years ago

    I might have not framed my question with clarity..but I wanted the output like this

     

    • v-henryk-mstf's avatar
      v-henryk-mstf
      Community Support
      5 years ago

      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.

       

      Here is the sample pbix file.


      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.


      Best Regards,
      Henry


      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.