cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Regular Visitor

## Measure Calculate at Lower Level

Hi everyone!

I am trying to create a type of VPM (Volume, Price, Mix) defined by my organisation.

I have the following

measures:

• Total cost
• Total cost LY
• Total Sales Volume
• Total Sales Volume LY
• LY Cost/Unit = Total Cost LY / Total Sales Volume LY
• Recalc LY Cost = LY Cost/Unit x Total Sales Volume

Here’s my issue (see below table).

If you have a look at the Recalc LY Cost and sum up the total for the two types of products, the result is \$516,833.

However, the current Total result returns \$536,215. This is because the LY Cost/Unit is calculated at the total level i.e. \$41.3 x 12,987 = \$536,215.

This is an important difference because the current total removes the weighting of the two products that would define the “Mix” impact.

Do you have any ideas about how I can write a measure that will return the same results for the two different different products but return \$516,833 for the total?

Thanks a lot,

Harry

1 ACCEPTED SOLUTION
Solution Sage

Dear @HarryPBI  ,
I hope this video solves your problem

if your problem is solved , do accept this as solution/
if you still have doubts let me know , i will try to help

regards ,
Thakur Sujit

Solution Sage

Dear @HarryPBI  ,
I hope this video solves your problem

if your problem is solved , do accept this as solution/
if you still have doubts let me know , i will try to help

regards ,
Thakur Sujit

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

#### Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors