DIVIDE AND MULTIPLY THE GRAND TOTAL ( COVERAGE)

[Anonymous]

Hi guys,

I'm trying to get the Coverage in a new column like this Excel table but in Power BI.

First I need to divide the Average price from the Client "A" between the grand total, then multiply per 100. 

Note: I need to do all this in a new column.

What do you recommended to use?

Best regard.

[v-jiascu-msft]

Hi @Anonymous ,

Try this one, please.

Coverage =
DIVIDE (
    [Average Price],
    DIVIDE ( SUM ( Table10[Total Sales] ), SUM ( Table10[Total Units] ) )
) * 100

Best Regards,

[Anonymous]

Mr. Thaks for your support.

The question here is if it's the same for a measure? I mean, I don't get a comumn in my "Data page". I have that table in the "Report Page" and all my columns are formulated with measures.

Regards

[v-jiascu-msft]

Hi @Anonymous ,

Could you please mark the proper answers as solutions?

Best Regards,

[Anonymous]

Sorry, I can't mark like a solution because didn't work for me. 

Best Regards.

[v-jiascu-msft]

Hi @Anonymous ,

If you need a measure, try this one, please.

Coverage =
DIVIDE (
    MIN ( 'table'[Average Price] ),
    CALCULATE (
        DIVIDE ( SUM ( 'table'[Total Sales] ), SUM ( 'table'[Total Units] ) ),
        ALL ( 'table' )
    )
) * 100

Best Regards,