Forum Discussion

robertomari2020

Helper I

6 years ago

Solved

Total 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...

Need Help

Anonymous

6 years ago

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

Anonymous

Not applicable

6 years ago

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