The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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%
Solved! Go to Solution.
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])
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])
Thank you so very much!
User | Count |
---|---|
15 | |
13 | |
8 | |
6 | |
6 |
User | Count |
---|---|
24 | |
19 | |
12 | |
9 | |
7 |