Percentage change to a reasonable calculation in the report

[Cevaro]

Hello,

I have the following report, which is made up of a Matrix Table.

I have marked the percentage sum in red, which I would like to change to a reasonable calculation in the report, so that it does not add up the individual percentages, but to make an arithmetic average.

Thanks for help 🙂 

[Cevaro]

Guys,

this is the Matrix Table I'm working with. I pulled in the Sales and Amount in LC data from two different tables that are connected by ID.
However, I would need to make another column here in the report that will contain the value "Sales * Coefficient (Coefficient is from the Amount in LC table) and then the value "Amount in LC / (Sales * Coefficient) * 100 (so that it is a percentage).

This is the assignment I was given. Is it possible to make a measure that would be able to provide me with these data, please.
Thank u 

[v-luwang-msft]

There @Cevaro ,

Try to use hasonevalue:

Refer the below sample:

new = if(HASONEVALUE('Table'[Type]),MAX('Table'[value]),AVERAGE('Table'[value]))

Output result:

Best Regards

Lucien

[parry2k]

@Cevaro not sure what you are looking for. can you provide more context? Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490