Forum Discussion

robertomari2020's avatar
robertomari2020
Icon for Helper I rankHelper 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's avatar
    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

robertomari2020's avatar
robertomari2020
Icon for Helper I rankHelper I
6 years ago

This problem is killing me... have been trying for days now 😞

Anonymous's avatar
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

  • robertomari2020's avatar
    robertomari2020
    Icon for Helper I rankHelper I
    6 years ago

    You are kidding me!

    Thanks a lot Anonymous !! It really works as expected!!!! You saved my week.

     

     

    And thanks also Greg_Deckler for helping me here!

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    6 years ago
    Nice one Anonymous !