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

qqqqqwwwweeerrr's avatar
qqqqqwwwweeerrr
Solution Sage
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