Forum Discussion

Krish35's avatar
Krish35
Frequent Visitor
5 years ago
Solved

Dynamic measure on date slicer

Hi everyone . We have 3 Tables connected with common columns something like below: 1.SCHOOL : SC_ID, SC_Name 2.STUDENT : ST_ID, ST_Name, SC_ID 3.TEST : ST_ID,TEST_ID, TEST_DT, Status   We are u...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Krish35 ,

     

    Check the measures.

    countpasstest = CALCULATE(COUNT(TEST[TEST_ID]),FILTER(TEST,TEST[Status]="pass"))

0test = CALCULATE(DISTINCTCOUNT(STUDENT[ST_ID]),FILTER(STUDENT,[countpasstest]=BLANK()))+0

1test = CALCULATE(DISTINCTCOUNT(STUDENT[ST_ID]),FILTER(STUDENT,[countpasstest]=1))+0

2test = CALCULATE(DISTINCTCOUNT(STUDENT[ST_ID]),FILTER(STUDENT,[countpasstest]=2))+0

3test = CALCULATE(DISTINCTCOUNT(STUDENT[ST_ID]),FILTER(STUDENT,[countpasstest]=3))+0

4test = CALCULATE(DISTINCTCOUNT(STUDENT[ST_ID]),FILTER(STUDENT,[countpasstest]=4))+0

5test = CALCULATE(DISTINCTCOUNT(STUDENT[ST_ID]),FILTER(STUDENT,[countpasstest]=5))+0

    Result would be shown as below.

    If you want let's say any 4 test contains any 3 test, you could use ">" instead of "=".

     

    Best Regards,

    Jay

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Krish35 , No of test passed

countx(summarize(TEST, TEST [ST_ID],TEST [TEST_ID], "_1", calculate(countdistinct([TEST_ID]),Filter(Test,[status]="Pass"))),[_1])

Krish35's avatar
Krish35
Frequent Visitor
5 years ago

Sir..Ithink I am not clear in my question..I want the out put something like this ..