topic how calculate percentage difference for two average calculated values in DAX Commands and Tips

how calculate percentage difference for two average calculated values

24031980 — Sat, 16 Mar 2024 14:25:20 GMT

Hi,

Wondering if anyone could help me please. All I wanted to calculate difference which on the circle. Please note that the English 45% and 38 is calculated average value.

Re: how calculate percentage difference for two average calculated values

lbendlin — Sat, 16 Mar 2024 17:47:45 GMT

Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?

Re: how calculate percentage difference for two average calculated values

24031980 — Sat, 16 Mar 2024 20:08:21 GMT

Hi, this is made on matrix table. The average in percentage in English assessment is from 628 pupils which is filter in PP and Non-PP. Now I would like to see what is the percentage gaps in PP and non-pp.

Thanks

Re: how calculate percentage difference for two average calculated values

lbendlin — Sat, 16 Mar 2024 20:40:22 GMT

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Re: how calculate percentage difference for two average calculated values

24031980 — Sat, 16 Mar 2024 21:16:04 GMT

FD3 =

VAR AverageOfPP =

CALCULATE(

AVERAGE('Attainment'[English (%)])

, FILTER('Context', 'Context'[PP] = "PP")

)

VAR AverageOfNonPP =

CALCULATE(

AVERAGE('Attainment'[English (%)])

, FILTER('Context', 'Context'[PP] = "Non-PP")

)

VAR Result = AverageOfNonPP - AverageOfPP

RETURN

Result

I am using this formula above. However it only substracts from PP column to PP however I wanted to substracted from non-pp to PP. For example 42% - 37% = 5% at FD3 column.

Re: how calculate percentage difference for two average calculated values

lbendlin — Sat, 16 Mar 2024 21:23:06 GMT

second request: Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Re: how calculate percentage difference for two average calculated values

24031980 — Sat, 16 Mar 2024 22:15:33 GMT

Hi,

I have managed to make it worked by using measure difference however the differences coming twice on the table how can I hide one.

Thanks

Re: how calculate percentage difference for two average calculated values

lbendlin — Sat, 16 Mar 2024 23:23:38 GMT

Sorry, can't assist without sample data. I hope someone else can help you further.

Re: how calculate percentage difference for two average calculated values

24031980 — Sun, 17 Mar 2024 23:37:09 GMT

Thank you, I have resolved by myself. Cheers