Create a Measure to Calculate ratio base on Amount in same colum

[FreedJustine]

Please help, i want to get % to REV base on Sub Catergory="Sales"

Below are the following measures i use.

Amount =sum(Report[AMT])

SalesAmt =

CALCULATE([Amount]),Report[Sub Catergory]="Sales")

% to Rev = DIVIDE([Amount],[SalesAmt])

Result should be

Sales 100%

Sales Discount 3%

Commission 10%

Thank you very much everyone ❤️

[rfigtree]

The denominator will be blank on your 2 dud rows.

Try this

SalesAmt =

CALCULATE([Amount]),filter(all(report[Sub category]),Report[Sub Catergory]="Sales"))

[FreedJustine]

Thanks @rfigtree but still the denominator is blank 😢