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

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

It looks to me that you should not be using EmployeeID in your SUMMARIZE. If I understand what you are going for, you should just need MonthYear.

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

    Hi Greg,

     

    thanks for you really(!) fast answer 🙂

    I tried it out like you said, but unfortunately still getting the wrong total... 😞

     

    This is what i tried, but still get the old result:

    To Be Fulfilled Service Jobs (h) uEoY 3 = 

VAR lineValue   =  [Open Service Jobs (h) uEoY]
                * DIVIDE([To Be Fulfilled Service Jobs (#) uEoY];[Open Service Jobs (#) uEoY])

VAR tempTbl = 
    SUMMARIZE(Tabelle1; 'Calendar'[MonthYear]; "ABCD"; lineValue)
    
RETURN
IF (HASONEVALUE('Calendar'[MonthYear]);
    lineValue;
    SUMX(tempTbl;[ABCD])
)
    • Greg_Deckler's avatar
      Greg_Deckler
      Icon for Community Champion rankCommunity Champion
      6 years ago

      Very difficult to troubleshoot these kinds of things. Any way you can share the PBIX? 

       

      Hmm, in taking a closer look at your image, try swapping the order of your EmployeeID and MonthYear in your SUMMARIZE so that it matches your hierarchy in your Rows area of the visual. So summarize by MonthYear and then EmployeeID?