Gross Margin Average

[espinozan]

Hello,

I'm trying to have a Card visual in my report that has the average percent of GM across all products. I currently have a measure that calculates GM. How can I have the Card visual show the average? Do I have to create a new measure? Or should it already be showing the average by default? Thank you for your help.

% GM = ((SUM(SAPdata[Total Revenue NBT])-
         SUM(SAPdata[Cost Sales Total]))/
         SUM(SAPdata[Total Revenue NBT]))

Best.

[v-ljerr-msft · Accepted solution]

Hi @espinozan,

If there is no any Slicers/Filters applied on your report, then the formula you provided above will calculates GM across all products. Or it will be calculated under the selected data.

To ignore all filters, and always calculates GM across all products, the formula below is for your reference. 

% GM =
CALCULATE (
    DIVIDE (
        SUM ( SAPdata[Total Revenue NBT] ) - SUM ( SAPdata[Cost Sales Total] ),
        SUM ( SAPdata[Total Revenue NBT] )
    ),
    ALL ( SAPdata )
)

Regards