Showing Incorrect Average for the column in Staright table.

[neha_shirsath]

Hi Folks,

I'm facing issue in showing incorrect average for columns highlighted in below image.

I'm using below expression for 1st column calculation and this is giving correct avg for 1st column but not for other -

=if(dimensionality()=1,Avg(Aggr(count({<[FileType]={"Opportunities"}, [Opportunity Lifecycle Status]={'Open'}>} distinct [Opportunity ID]), [Sales Enginner Description])),
Count({<[FileType]={"Opportunities"}, [Opportunity Lifecycle Status]={'Open'}>} DISTINCT [Opportunity ID]))

Thanks in advance.

-Neha

[jonathandienst]

I suggest that a small QVW flle to illustrate the problem. The data does have to be "real", but the data model should be representative. In addition outline the expected amount and the calculation required. The expression you posted is useful, but not enough.