Variables that are not affected by filters

[Anonymous]

Hello

I am wanting to create a KPI showing the average value of all values in the field

and also another KPI which will show the average value from the values in the field which have been selected in the filter table

i.e.

KPI 1

KPI 2

Filter table

A

B

KPI 1 - Shows the average for all values and will not change when something is selected in the filter table 

KPI 2 - Shows the average and will be affected by the filter table

If its possible to do this any help would be appreciated

Thank you

[lironbaram · Accepted solution]

hi

kpi 1 : avg {1}Value) - this will always display the same result

Kpi 2 : avg(Value)

[aarkay29]

lets say Filter Table field is Dim1

KPI1 - Avg({1<Dim1=>}Amount)

KPI2 - Avg(Amount)

[ahaahaaha]

Hi,

For example,

KPI 1:  Avg([Your expression])

KPI 2: Avg({1}[Your expression])