Forum Discussion
Help with Measure
Hi, Anonymous
In the previous table I set the Value of Altona North and Armadale to be the same as Alexandria to save time, so there will be no change when filtering.
I have adjusted the data, please download the latest attachment.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi v-zhangti again,
The measure values are giving me wrong values.
My guess is - this is because the CQF table has more than 1 location
Could I please get some help with tweaking the measure?
Arrgh so close!!
Thanks so much for your time and assistance!
Hi, Anonymous
Except measure, the others remain unchanged.
Measure =
VAR _a =
SUMMARIZE (
FILTER (
ALL ( CQF ),
[Date] <= MAX ( 'Dim-date'[Month End] )
&& [Location] = MAX ( CQF[Location] )
),
[Location],
[Last date],
"avg", AVERAGE ( CQF[Value] )
)
VAR _B =
TOPN ( 1, _a, [Last date], DESC )
RETURN
MAXX ( _B, [avg] )
Add a condition about filtering location in measure.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi v-zhangti,
The table seems to be working fine. However, the line graph does not seem to update with filter selection.
Would you be help (hopefully for the last time!)
Again, appreciate your help so much!
Hi, Anonymous
In the previous table I set the Value of Altona North and Armadale to be the same as Alexandria to save time, so there will be no change when filtering.
I have adjusted the data, please download the latest attachment.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.