Forum Discussion
Weekly measures returning blanks!
Hi,
Please try to use this measure to show Average engagement for this week:
Average engagement rate for this week =
AVERAGEX (
SUMMARIZE (
DateKey,
'DateKey'[Date],
"T", AVERAGEX (
FILTER (
ALLSELECTED ( DateKey ),
'DateKey'[Week #] = SELECTEDVALUE ( 'DATA'[WEEK NUM] )
),
[Ave Eng Rate]
)
),
[T]
)
And the result shows:
Here is my test pbix file:
Best Regards,
Giotto Zhi
Hi v-gizhi-msft ,
Thank you for your help!
This solves the 'blank' issue, but the numbers aren't looking quite right...
The 'average for last week' measure doesn't match when i check it in a table against the 'eng rate' metric, averaged by week:
https://www.dropbox.com/s/1vlhf94dgeeinvf/Case-Weekly%20measures%20returning%20blanks%21.pbix?dl=0
Thanks again,
Sonia
Hi,
Please try to use this measure to show Average engagement for this week:
Average engagement rate for this week =
AVERAGEX (
SUMMARIZE (
DateKey,
'DateKey'[Date],
"T", AVERAGEX (
FILTER (
ALLSELECTED ( DateKey ),
'DateKey'[Week #] = SELECTEDVALUE ( 'DATA'[WEEK NUM] )
),
[Ave Eng Rate]
)
),
[T]
)
And the result shows:
Here is my test pbix file:
Best Regards,
Giotto Zhi