Filtering on a summarize function in DAX

[Anonymous]

Hi All!

If I have the following DAX calculation: 

averagex(summarize('Table1', 'Table1'[Asset],"_Sum",sum('Table1'[Downtime])),[_Sum])

How could I put a filter on this calculation so it only does the calculation over a filtered other column let's say

'Table1'[Plan_type]="Plan A"

? 

[amitchandak · Accepted solution]

@Anonymous , It can be like this

averagex(summarize(filter('Table1','Table1'[Plan_type]="Plan A"), 'Table1'[Asset],"_Sum",sum('Table1'[Downtime])),[_Sum])

Or part of the formula _sum

or you can use a slicer on page

[Anonymous]

@amitchandak thank you very much!