dax formula to calculate percentage of trends

[Arpita-2024]

i wanted to make a chart on trends of students performance,

category Above, At and Below and three academic year 22-23, 23-24, 24-25

I want percentage of above, At and Below in 3 consecutive year . 3 years of above, 3 years of at and 3 years of below

as count I am getting the chart but not in percentage .. need help

[Anonymous]

Hi @Arpita-2024 ,

Is my follow-up just to ask if the problem has been solved?

If so, can you accept the correct answer as a solution or share your solution to help other members find it faster?

Thank you very much for your cooperation!

[Anonymous]

Hi @Arpita-2024 ,

I am not sure how your semantic model is designed, below is my example.

The test data is as follows.

Create a measure to calculate a percentage for each category.

Percentage = 
VAR Total =
    CALCULATE (
        SUM ( 'Table'[Count] ),
        ALLEXCEPT ( 'Table', 'Table'[Academic Year] )
    )
RETURN
    DIVIDE ( SUM ( 'Table'[Count] ), Total, 0 )

Then create a chart using that measure. The result is shown below. Hopefully this will meet your needs.

Please see the attached pbix file for reference.

Best Regards,
Dengliang Li

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

[mark_endicott]

@Arpita-2024  - Have a read through this and you'll find out how to get this question answered faster:

https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-Get-Your-Question-Answered-Qu...