Change the total in a table

[PwrBI01]

Hi guys,

I have the following table:

In the column real number, the total is a sum of all the groups (each of them calculated as Sales Comercial 1/Total Sales) and I would like to get the average.

I will appreciate your help.

Thanks in advance.

Regards.

[amitchandak]

@PwrBI01 , Better to have measure like this

divide(sum(Table[Sales Comercial 1]),sum(Table[Total Sales]))

if you need simple avg

Averagex(Table, divide((Table[Sales Comercial 1]),(Table[Total Sales])))

[PwrBI01 · Accepted solution]

Hi @amitchandak, thank you for your answer.

I tried your measure but it did not calculate the right result, I solved it with this measure:

Forced number = IF(NOT(ISFILTERED('GROUP'[Group]));[Sales of comercial 1]/[Total sales];Real number))