Forum Discussion
AliceInChains
8 years agoFrequent Visitor
Averages not updating when Visualization Filter applied
Hello there, I have the folloing calculation for MeanDays: MeanDays = format(INT((average('Property and Admin Unit'[nDays])) / 365), "000") & " Years " & format(INT(divide(Mod((average('Pro...
- 8 years ago
Hi AliceInChains,
I haven't see the meandays measure in your screenshot, please add ALLSELECTED(Table) in your formula to create a measure rather than calculated column and check if it works fine.MeanDays = FORMAT ( INT ( ( AVERAGEX ( ALLSELECTED ( 'Property and Admin Unit' ), 'Property and Admin Unit'[nDays] ) ) / 365 ), "000" ) & " Years " & FORMAT ( INT ( DIVIDE ( MOD ( ( AVERAGEX ( ALLSELECTED ( 'Property and Admin Unit' ), 'Property and Admin Unit'[nDays] ) ), 365 ), 30 ) ), "00" ) & " Months " & FORMAT ( INT ( MOD ( MOD ( ( AVERAGEX ( ALLSELECTED ( 'Property and Admin Unit' ), 'Property and Admin Unit'[nDays] ) ), 365 ), 30 ) ), "00" ) & " Days"
Please respond to us if you have any other issue.
Best Regards,
Angelia
v-huizhn-msft
8 years agoMicrosoft Employee
Hi AliceInChains,
I haven't see the meandays measure in your screenshot, please add ALLSELECTED(Table) in your formula to create a measure rather than calculated column and check if it works fine.
MeanDays =
FORMAT (
INT (
(
AVERAGEX (
ALLSELECTED ( 'Property and Admin Unit' ),
'Property and Admin Unit'[nDays]
)
)
/ 365
),
"000"
)
& " Years "
& FORMAT (
INT (
DIVIDE (
MOD (
(
AVERAGEX (
ALLSELECTED ( 'Property and Admin Unit' ),
'Property and Admin Unit'[nDays]
)
),
365
),
30
)
),
"00"
)
& " Months "
& FORMAT (
INT (
MOD (
MOD (
(
AVERAGEX (
ALLSELECTED ( 'Property and Admin Unit' ),
'Property and Admin Unit'[nDays]
)
),
365
),
30
)
),
"00"
)
& " Days"
Please respond to us if you have any other issue.
Best Regards,
Angelia
AliceInChains
8 years agoFrequent Visitor
It worked... I had to convert the calculated columns into measures by completely re-constructing the claculation... Its a pitty that you can not simply convert the calculated column into a measure ......