topic Getting % of an average column in DAX Commands and Tips

Getting % of an average column

Anonymous — Wed, 04 May 2022 15:02:45 GMT

Hello I am trying to get the % of a column when this column values are the average.

Basically want for my Avg of Days to be summed out (Total should be = 156.27) and then in the next column where I underlined the number for it to be 17.47 / 156.27 = 11.18%

Re: Getting % of an average column

johnt75 — Wed, 04 May 2022 15:27:19 GMT

Avg as % = var summaryTable = ADDCOLUMNS( ALLSELECTED('Table'[Request PBI]), "@val", CALCULATE(AVERAGE('Table'[Days]))) var currentValue = CALCULATE(AVERAGE('Table'[Days])) return DIVIDE( currentValue, SUMX(summaryTable, [@val])

Re: Getting % of an average column

Anonymous — Wed, 04 May 2022 15:32:12 GMT

Thank you so very much!