Forum Discussion
KPI Visual target as average
I have a KPI visual for which the Value shows accurately as the last period of the year but the Target shows the same, where I want to show the average of that year's values.. See below ...
Hi Anonymous,
I'm not sure about the exact formula in your scenario because sample data does not match the logic in your formula but my best guess would be a calculation similar to that one:
Avg =
CALCULATE(
AVERAGEX(
ADDCOLUMNS(
SUMMARIZE(tbl2, tbl2[Period]),
"@sum", CALCULATE([Value Sum])
),
[@sum]
),
ALL(tbl2[Period])
)Thank you, it might be my data configuration, I get the same old results when using your formula