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:
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
Anonymous it made a few changes and now it works.
The trick was that i was still using a calculated column in the visual instead of the measure