topic Re: dax formula to calculate percentage of trends in DAX Commands and Tips

dax formula to calculate percentage of trends

Arpita-2024 — Wed, 18 Dec 2024 13:50:32 GMT

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

Re: dax formula to calculate percentage of trends

mark_endicott — Wed, 18 Dec 2024 14:02:17 GMT

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-Quickly/m-p/1626726#M32906

Re: dax formula to calculate percentage of trends

Anonymous — Thu, 19 Dec 2024 05:18:34 GMT

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.

Re: dax formula to calculate percentage of trends

Anonymous — Mon, 30 Dec 2024 08:30:29 GMT

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!