Forum Discussion
How to filter rows greater than the average?
In Power BI Desktop, I have a measure: 'Measure_Average' which computes the average of all values in the column: [Amount] in the table: 'Billing'. My question is: how do I create a table visual and s...
Hi Anonymous ,
You can create column Average to get a fixed value, and create measure Filter1 ,then put measure Filter1 in the Visual Level Filter of table visual displaying the [Amount] , and setting the Filter1 as "is not blank".
Average = AVERAGE(Billing[Amount])
Filter1 = IF(MAX(Billing[Amount])>MAX(Billing[Average]),1,BLANK())
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
bvilten
Helper III
Helper IIIIf you want to show the averages then you won't need the measure. Just drag a column Company (Just assuming on my part) into a table display then drag the Amount column in. Change the display of Amount to Average. Then set the visual filter to "is greater than".