Show a card with % of total

[Anonymous]

I am trying to show the % of total sales that are made Product Revenue but keep getting an error or incorrect value when I try it.

2020 Sales	Sales Code
$45	Advertising
$300	Product Revenue
$5	Service Fees
$65	Advertising
$35	Other

Product Revenue % ($300) / Total Revenue ($450) = 66.7%

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

Create a measure

Measure = CALCULATE(SUM(Sheet8[2020 Sales]),FILTER(Sheet8,Sheet8[Sales Code]="Product Revenue"))/CALCULATE(SUM(Sheet8[2020 Sales]),ALLSELECTED(Sheet8))

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[edhans]

You want somethings along the lines of this. The ALL() in the denominator tells it to ignore all filters and get the entire total.

% of Total =
VAR CurrentSales =
    SUM( Table[Sales] )
VAR TotalSales =
    SUMX(
        ALL( Table ),
        Table[Sales]
    )
VAR Result =
    DIVIDE(
        CurrentSales,
        TotalSales,
        0
    )
RETURN
    Result