% and $ value of Profit

[Peter_Yaacoub]

Hi @Greg_Deckler @amitchandak ,

Using measures, I have built a P&L in a matrix visual with scenarios (Actual vs. Budget vs. Last Year) in columns.

I have another table with company names and each company’s percentage share of the profit, and a separate date table.

I need help with the formula to calculate each company’s Dollar Share of the profit. (Report has date and company slicers).

Below are snapshots of the tables I am using:

Your help is much needed and appreciated.

Thank you in advance!

[v-tangjie-msft]

Hi @Peter_Yaacoub ,

Thank you for providing us with some sample data! According to the description of your post, you want to calculate the dollar profit share of each company, but I am not very clear about the business logic of your company, and I don't know what kind of end result you want to get from this data. Can you provide us with the following calculation logic for this problem?

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution to help the other members find it more quickly.