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

Helper II

## Total of Measure doesnt work

Hi,

I have a measure that calculates Projected Qty on Hand in warehouse based on Qty and Demand, calculation is all good on item level but i can not crack it how to approach to make a summary of it.

My fact table consist of dates of transations only on part level, not all dates.

What is calculated in measure is a date of last transaction and based on that i take the calculation Qty-Demand and then i have Projected Qty, as below it is ok for each item:

I have tried the @Greg_Deckler approach with SUMMARIZE but it did not worked here, what i expect to see is to have correct totals and then present data with no part number in matrix/table.

Pbix with sample data:  https://1drv.ms/u/s!AoXSL5pl9luJdKfujLoyId2OVDo?e=IVH1xi

Any advise 🙂 ?

1 ACCEPTED SOLUTION
Super User

Hi @mhsk ,

Add the following measure to your model:

``````Projection Total =
IF (
ISINSCOPE ( Extract_ld_det_Items[ld_part] ),
[Projection QOH],
SUMX (
SUMMARIZE (
ALLSELECTED (
Extract_ld_det_Items[ld_part],
Extract_ld_det_Items[Extract_mrp_det (2).Start of Week]
),
Extract_ld_det_Items[ld_part],
"ProjectionValue", [Projection QOH]
),
[ProjectionValue]
)
)``````

Regards

Miguel Félix

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português

4 REPLIES 4
Super User

Hi @mhsk ,

Add the following measure to your model:

``````Projection Total =
IF (
ISINSCOPE ( Extract_ld_det_Items[ld_part] ),
[Projection QOH],
SUMX (
SUMMARIZE (
ALLSELECTED (
Extract_ld_det_Items[ld_part],
Extract_ld_det_Items[Extract_mrp_det (2).Start of Week]
),
Extract_ld_det_Items[ld_part],
"ProjectionValue", [Projection QOH]
),
[ProjectionValue]
)
)``````

Regards

Miguel Félix

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português

Helper II

@mfed yes, this code solves my issue totally! Great job!

Unfortunatelly i can see i have another issue, my calculation is not as expected on previous step, what i was trying to to is to QOH (QOH_NOW) - Running Total of Demand (SUP-DEM_3) , to calculate Projection each next week.
and again as it works on SUP-DEM_3 level but not if i wrap it up into next measure  Projected QOH

have an idea?

Helper II

So to add a comment, i end up with having a correct date on which i need a measure value but can not get this measure value (so the previous value - Projection QOH)

Super User

Paste your DAX here bro

Did I answer your question? If so, please mark my post as a solution!

Proud to be a Super User!

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 - August 2024

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

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors