Need Help creating advanced measures based off of other measures

[Anonymous]

Hello all,

I am fairly new to PowerBI and as i build my data model im running into some issues with advanced metrics/calculations.  I have been able to create metrics for sales % and unit % mix but now im trying to create a % mix for these calculated measures called Bleeders and Leaders (Delta Association Terminology).

The Measures I created, Bleeders and Leaders, show the Categories that have either declined (Bleeders) YoY, MoM or PoP and have gained (Leaders) PoP.  Now what i want to do is create a % Mix for both so i can report not only the ABS $ amount the category is up or down but also the % of the bleeders or Leaders it represets.

I know how to calculate this in PowerPivot but i cant seem to get it to work with in PowerBI Desktop itself.

Any Help would be much appreciated and i can give more examples or a better explanation if needed.

Thanks,   

[v-yuta-msft]

@Anonymous ,

Have you solved your issue by now? If you have, could you please help mark the correct answer to finish the thread? Your contribution will be much appreciated.

Regards,

Jimmy Tao

[Anonymous · Accepted solution]

I was able to solve for % Mix but not the more advanced metrics.  If people need the solution, i will be happy to provide for % mix.

Thanks!

[v-yuta-msft]

@Anonymous ,

---

I am fairly new to PowerBI and as i build my data model im running into some issues with advanced metrics/calculations.  I have been able to create metrics for sales % and unit % mix but now im trying to create a % mix for these calculated measures called Bleeders and Leaders (Delta Association Terminology).

The Measures I created, Bleeders and Leaders, show the Categories that have either declined (Bleeders) YoY, MoM or PoP and have gained (Leaders) PoP.  Now what i want to do is create a % Mix for both so i can report not only the ABS $ amount the category is up or down but also the % of the bleeders or Leaders it represets.

---

To be general, can abs([measure1] - [measure2]) work? If can't, could you share some sample data and clarify the logic of how to achieve a %Mix measure?

Community Support Team _ Jimmy Tao

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