Forum Discussion

Aha2022's avatar
Aha2022
Regular Visitor
4 years ago
Solved

Profit by product

 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's avatar
    tamerj1
    4 years ago

    Hi Aha2022 

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

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

1 Reply

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Hi Aha2022 

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

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