Forum Discussion

shoeb1359's avatar
shoeb1359
Helper III
1 year ago
Solved

Latest Data visualization based on filter selection

Hello Experts I have a scenario where I need to display total no of students enrolled in different schools, with a month filter (multi-select). Challenge here is, some students got transferred from...
Need Help
  • qqqqqwwwweeerrr's avatar
    qqqqqwwwweeerrr
    1 year ago

    Hi shoeb1359 

     

    You can achieve this by creating three measure

    1. 

    Latest Enrollment =
    CALCULATE(
        COUNTROWS(
            DISTINCT('Enrollment'[Student id])
        ),
        FILTER(
            'Enrollment',
            'Enrollment'[IsCurrent] = "Yes"
        )
    )
    2. 
    Students Per Month =
    CALCULATE(
        COUNTROWS(
            DISTINCT('Enrollment'[Student id])
        ),
        REMOVEFILTERS('Enrollment'[IsCurrent])
    )
    3. 
    Final Student Count =
    IF(
        ISFILTERED('Enrollment'[Month Year]),
        [Students Per Month],
        [Latest Enrollment]
    )use thired meaure in axis of a chart here is the output 
    when nothing is selected the latest one be is shown

    when selected in filter

    Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
    Check for more intersing solution here: www.youtube.com/@Howtosolveprobem

    Regards

shoeb1359's avatar
shoeb1359
Helper III
1 year ago

Thanks it's working . Keep up the good work