topic Re: Profit by product in DAX Commands and Tips

Profit by product

Aha2022 — Sat, 01 Oct 2022 05:24:14 GMT

I have to craete a profit by product % measure and the formula is Profit by Product (%)= Product Profit/ total Profit

I already create a profit measure

Thanks in advance.

tamerj1 — Sat, 01 Oct 2022 05:57:32 GMT

it depends on your dara model and filter context. In general you can try something like

DIVIDE ( [Profit], CALCULATE ( [Profit], ALLSELECTED ( 'Table'[Product Name] ) )