Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Create measure in Power BI

I am working on Sample Superstore dataset where I have Sales, Quantity, Profit and discount. I will need to calculate sales per quantity, profit per quantity and discount per quantity.   I'm curren...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    Hi,

    You should write that as a measure (not as a calculated column formula).  Also, break down your measures to:

    Revenue = SUM(Orders[Sales])

    Qty sold = SUM(Orders[Quantity])

    Rev per unit = divide([Revenue],[Qty sold])

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
3 years ago

Hi,

You should write that as a measure (not as a calculated column formula).  Also, break down your measures to:

Revenue = SUM(Orders[Sales])

Qty sold = SUM(Orders[Quantity])

Rev per unit = divide([Revenue],[Qty sold])

Hope this helps.