Forum Discussion
Calculation
Hi, I want to create a measure to get the smallest average taken from a list. Two screenshots below, show the data format and the visual I have taken. I now want to use a meas...
- Hi AnonymousI took a look at your pbix and mistakenly thought you had calculated the average.
You need to create a calculated column to calculate the average:average_col = CALCULATE( AVERAGE('Scores by check (2)'[Value]), FILTER(ALLSELECTED('Scores by check (2)'), 'Scores by check (2)'[Attribute]=EARLIER('Scores by check (2)'[Attribute])))Then create a measure to calculate the minimum average:
Measure = MINX('Scores by check (2)','Scores by check (2)'[average_col])It works like this:Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Will this work for what you're trying to do?
DOC//SigMatches AVG = CALCULATE( AVERAGE('Table'[Score]) , 'Table'[Check] = "DOC//SigMatches" )
Hi CoreyP
That will work in this instance however this will be a live report with new data being pushed through periodically, meaning that the lowest average will change from DOC//SigMatches