Forum Discussion
robertomari2020
Helper I
Helper ITotal doesnt add up the line values - even when using HASONEVALUE
Hi everyone, thanks for this great community! Helped me a lot so far! Before posting this I was reading a loooot of other posts and tried to implement it in the recommended ways but after long t...
Hi robertomari2020 ,
Please try to update the format of measure "To Be Fulfilled Service Jobs (h) uEoY 3" as below:
To Be Fulfilled Service Jobs (h) uEoY 3 = SUMX ( VALUES ( 'Calendar'[MonthYear] ), SUMX ( VALUES ( 'Tabelle1'[EmployeeID] ), [Open Service Jobs (h) uEoY] * DIVIDE ( [To Be Fulfilled Service Jobs (#) uEoY], [Open Service Jobs (#) uEoY] ) ) )Best Regards
Rena
robertomari2020Helper I
Helper IHi Greg, tried to swap the summarize column order, but also didnt work... 😞
Can you get the file from here? https://www.dropbox.com/s/q0yflxt6l311zyk/total_not_summing_up_correctly.pbix?dl=0
Thank you for your help and time already!
Greg_Deckler
Community Champion
Community ChampionSo, if you replace your SUMX with this:
CONCATENATEX(tempTbl,FORMAT([ABCD],"#.##"),",")
You can see that the first three months match the numbers identically and then things start to diverge. I do not know why. I suspect that somewhere within the nest of measures a filter or something else that is critical to the calculation is going awry or being overridden. It is really difficult to say as the measure nesting is formidable.
CONCATENATEX(tempTbl,FORMAT([ABCD],"#.##"),",")
You can see that the first three months match the numbers identically and then things start to diverge. I do not know why. I suspect that somewhere within the nest of measures a filter or something else that is critical to the calculation is going awry or being overridden. It is really difficult to say as the measure nesting is formidable.
- robertomari2020
hmm that could be helpful to trace the error.... but when I replace sumx i get the same value over and over
- robertomari2020
This problem is killing me... have been trying for days now 😞
Hi robertomari2020 ,
Please try to update the format of measure "To Be Fulfilled Service Jobs (h) uEoY 3" as below:
To Be Fulfilled Service Jobs (h) uEoY 3 = SUMX ( VALUES ( 'Calendar'[MonthYear] ), SUMX ( VALUES ( 'Tabelle1'[EmployeeID] ), [Open Service Jobs (h) uEoY] * DIVIDE ( [To Be Fulfilled Service Jobs (#) uEoY], [Open Service Jobs (#) uEoY] ) ) )Best Regards
Rena