Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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 🙂 ?
Solved! Go to Solution.
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
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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
Proud to be a Super User!
Check out my blog: Power BI em Português@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?
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)
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!
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
107 | |
106 | |
91 | |
67 |
User | Count |
---|---|
162 | |
133 | |
132 | |
93 | |
91 |