topic Re: Largest average dviation per product in a column in DAX Commands and Tips

Largest average dviation per product in a column

Anonymous — Thu, 02 Feb 2023 09:06:45 GMT

Hi,

I have a (large) table that looks something like this:

In this random example, the average weight deviations are:

Product A: +2,2 % //

Product B: +3,6 % //

Product C: -0,33 %

I need a measure to, in this case, pick put "Product B" for the largest average weight deviation.

Any suggestions?

Anonymous — Thu, 02 Feb 2023 10:02:51 GMT

I think I can do it with this formula:

MaksProd = VAR MaxAvProd =

MAX ( 'Table'[AverageWeight] )

RETURN

CALCULATE (

SELECTEDVALUE ( 'Table'[ProductName] ),

'Table'[AverageWeight] = MaxAvProd

)

But then I just need to create a column with the averages per product (that shows the value 2,2 for each row with product A and so on.. )

hmm...

Anonymous — Thu, 02 Feb 2023 10:28:45 GMT

I tried this:

Kolonne =

AVERAGEX(

KEEPFILTERS(VALUES('Table'[ProductName])),

CALCULATE(AVERAGE('Table'[Weightdifference]))

)

But then I get a circular dependency issue.... :'(

Anonymous — Wed, 08 Feb 2023 09:39:11 GMT

Hi Anonymous ,

Please have a try.

Create measures.

Measure = AVERAGEX(FILTER(ALL('Table'),'Table'[Product]=SELECTEDVALUE('Table'[Product])),'Table'[Weight Actual])

measure2=maxx(all(table),[measure])

Or a column.

column = AVERAGEX(FILTER(ALL('Table'),'Table'[Product]=EARLIER('Table'[Product])),'Table'[Weight Actual])

measure=maxx(all(table),table[column])

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.