Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 ...
Need Help
Show and Tell
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    6 years ago

    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's avatar
amitchandak
Super User
6 years ago

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's avatar
    Anonymous
    Not applicable
    6 years ago

    amitchandak thank you very much!