Forum Discussion

ngct1112's avatar
ngct1112
Post Patron
4 years ago
Solved

DAX - Filter before Summarize

Hi All, I would like to seek some helps for the DAX to summarize the "QTY" by "ID". However, I would like to Filter the "Status" to Ordered only before summarize. ID QTY Status 1 7 Ordere...
Need Help
  • FarhanAhmed's avatar
    FarhanAhmed
    4 years ago

    Try

    _Table = 

SUMMARIZE(FILTER('Table','Table'[Status]="Ordered"),'Table'[ID], 
"SUM", CALCULATE(SUM('Table'[QTY])))
FarhanAhmed's avatar
FarhanAhmed
Community Champion
4 years ago

Try

_Table = 

SUMMARIZE(FILTER('Table','Table'[Status]="Ordered"),'Table'[ID], 
"SUM", CALCULATE(SUM('Table'[QTY])))
  • ngct1112's avatar
    ngct1112
    Post Patron
    4 years ago

    FarhanAhmed  you solution works very fine. May I know how it is possible that your solution can still work without ADDCOLUMN?
    Great thanks anyways