Compute Avg metric

[RajuNatesan]

I have two columns COL_A & COL_B and I want to compute the Avergae for COL_B  only on the rows that is returned based on the Unique values on COL_A.

I tried this expression in the KPI Chart, But still I am getting the incorrect average.

Num(Avg(Aggr(Count(distinct [COL_A ]),COL_B )), '#,##0') &'(in days)'

Any help here pls

[vincent_ardiet_]

Could you illustrate with an example of dataset and excepted results?

[RajuNatesan]

@vincent_ardiet  - Attached a sample file as requested. Average on COL_B KPI should return 60.8 considering the rows based on unique values from COL_A.

[vincent_ardiet_ · Accepted solution]

You can try something like: Avg(Aggr(Only(COL_B),COL_A))

[RajuNatesan]

Thanks @vincent_ardiet_ - It worked.