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.