Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

SUMMARIZE Not Returning Correct Sum Value

Hello,   I'm trying to perform a SUM of the Production Qty at the Scheduled Shift level which is the next level of granularity from MATERIAL_NUMBER but I'm not getting the correct summation. I perf...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Using the "Group By" functionality in Power Query Editor worked for me. I followed the instructions near the bottom of this article link...Link 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Here's the DAX behind the measure...

 

Production Qty (Date-PlantNum-PlantType-ProdLine-Shift) =
SUMX(
SUMMARIZE('HANA Production Fact','HANA Production Fact'[Scheduled Date], 'HANA Production Fact'[Plant], 'HANA Production Fact'[COS Production Line], 'HANA Production Fact'[Scheduled Shift],"Production Qty 1",CALCULATE(SUM('HANA Production Fact'[Production Quantity]))),[Production Qty 1])
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Maybe this will work...

 

CALCULATE(
SUM('HANA Production Fact'[Production Quantity]),
ALLEXCEPT(HANA Production Fact,
'HANA Production Fact'[Scheduled Date],
'HANA Production Fact'[Plant],
'HANA Production Fact'[COS Production Line],
'HANA Production Fact'[Scheduled Shift]
)
)