Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Wrong Totals

Hi guys,   I am trying to create my own forecast because it is based on a planning. To do this I have a few measures and some data to go with it.   Measure to determine the price of the hours in...
Need Help
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Greg_Deckler ,

     

    I have been trying your solution, but I am not sure how to continue.

    I made this measure:

     

    MyMeasure2 =
    VAR __table = SUMMARIZE(TimeTransactions;[Project];"__value"; [GuideLine])
    Return
    IF(HASONEVALUE(TimeTransactions[Project]); [GuideLine];SUMX(__table; [__value]))
     
    But it gives me even weirder values
     
     
    Can you help me?
     
    Best regards,
    Queenie

     

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

      Try this:

       

      MyMeasure2 =
VAR __table = SUMMARIZE(TimeTransactions;[Maand];"__value"; [GuideLine])
Return
IF(HASONEVALUE(TimeTransactions[Project]); [GuideLine];SUMX(__table; [__value]))

       

      You should summarize by whatever you are summarizing by in your table visualization (it looks like "Maand"). The value (__value) should be the measure you want to aggregate correctly in the total line.