Divide a measure by two measure based on a dimension

[pvtrinh89]

Dear Experts,

I have a measure named sales containning amount of two lines retail and direct, so now i want to divide sales by 2 measures name sales_retail and sales_direct but i am unable to research for this, Did power bi can do that? has anyone can let me know the solution to compare between retail nad direct if power bi can not support to divide the sales measure.

Best regards.

J.

[Greg_Deckler]

@pvtrinh89, What @Sean says is correct in so far as the assumptions around your data model hold. Are you able to post sample data so that those assumptions can be confirmed or the solution can be modified to fit your data?

[pvtrinh89]

Hi Smoupre,

I have done as Sean help, thank for your support 🙂

[Sean · Accepted solution]

So you have a Measure named SALES

and you want to have 2 Measures SALES RETAIL = CALCULATE([SALES], TableName[Sales Category Column]="Retail")

and same for SALES DIRECT = CALCULATE([SALES], TableName[Sales Category Column]="Direct")

You can of course just create a Matrix add Sales Category and SALES Measure you already say you have and it will show you both Categories split.

But if you want 2 separate measures this should help you.

[pvtrinh89]

Thanks Sean so much!

this is exactly i want to do.