topic Re: Create a Measure to Calculate ratio base on Amount in same colum in DAX Commands and Tips

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

FreedJustine — Sat, 27 Feb 2021 08:05:53 GMT

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 — Sun, 28 Feb 2021 01:31:27 GMT

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 — Mon, 01 Mar 2021 01:18:48 GMT

Thanks rfigtree but still the denominator is blank 😢