Forum Discussion
Filtering on a summarize function in DAX
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"?
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
2 Replies
- amitchandak
Super User
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
amitchandak thank you very much!