how calculate percentage difference for two average calculated values

[24031980]

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. 

[24031980 · Accepted solution]

Thank you, I have resolved by myself. Cheers

[24031980]

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

[lbendlin]

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

[24031980]

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

[lbendlin]

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-...

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/1447...

[lbendlin]

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

[24031980]

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. 

[lbendlin]

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-...

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/1447...