Calculate Average regardless of Visual Level Filters

[Anonymous]

I uploaded a spreadsheet of 25000 rows of data.  Column A shows an order number. Column B shows the order total.  I want to map the Top 10 orders and show their average out of 25000.  But Power BI shows their average of the Top 10.    

Is there a work around for this?

[Vvelarde]

@Anonymous

Hi, create a measure to calculate the average over total:

Avg-over-Total =
DIVIDE (
    SUM ( Table1[Total Order] ),
    CALCULATE ( SUM ( Table1[Total Order] ), ALL ( Table1 ) )
)

Regards

Victor

Lima - Peru