Forum Discussion
How to average the values when doing multiple selection from a filter
I have a block on my task. Can anyone please help me to solve it? I create a Tachometer gauge, and I want to display KPI value in one month if I select a month from a filter. That's OK for single mo...
HI nzkevin003,
If your value fields store column, you can try to modify its summary mode to 'average' to achieve this requirement.
If not, you need to modify your measure formula to create variable summarize table, then do average calculation on this summary table.
Regards,
Xiaoxin Sheng