Forum Discussion
HELP !! simple calculation ?!
Modeling -> New measure, and copy the code:
Cumulatieve HP gerealiseerd =
CALCULATE ([Totaal aantal HP];
FILTER(
ALL(Forecast);
'Forecast'[Week]<=MAX(Forecast[Week])
)It will work as a line or bar graph. Put a Date dimension on the Axis and your newly created measure to Values.
For me it looks like this:
BobBI thanks for the reply but it doesn't work just yet.
Ive added the measure and the formula but it just returns the same value on all rows.
The only thing i can see is that you have 2 colums for the Year-Week (Col1 and Col2) and i have one column (Week)
Totaal aantal HP = SUM(Forecast[Aantal HP gerealiseerd])
Cumulatieve HP gerealiseerd =
CALCULATE ([Totaal aantal HP];
FILTER(
ALL(Forecast);
'Forecast'[Week]<=MAX(Forecast[Week])
)
)
Hi RvdHeijden,
try to create a measure out of the Cumulative HP gerealiseerd calculation instead of a calculated column.
Regards,
Barna
Anonymous
How ?
Besides i need this data for a bar or a line graph so does that still work if i use a measure ?
Modeling -> New measure, and copy the code:
Cumulatieve HP gerealiseerd =
CALCULATE ([Totaal aantal HP];
FILTER(
ALL(Forecast);
'Forecast'[Week]<=MAX(Forecast[Week])
)It will work as a line or bar graph. Put a Date dimension on the Axis and your newly created measure to Values.
For me it looks like this:Anonymous
It still doesn't work, it still returns the same value and ive copied your formula.
The measure for Totaal aantal HP is different i think because you use 2 columsn Col1 and Col2 and i have 1 colum