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, 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.