Forum Discussion
Sumx with filter over another Table
Hi All I am exactly requiring what microsoft is showing in below example: https://docs.microsoft.com/en-us/dax/sumx-function-dax The only differnece is that I need the filter from table "Lia...
Anonymous , Try like
Turnover OTC (Number) Spread orders current year vs. last year (Number) = CALCUALTE(SUM('Lian CH$Sales Invoice Line'[Quantity]),FILTER('Lian CH$Item','Lian CH$Item'[Item Group Code] = "A-Liste-C"))
amitchandak
Super User
Super UserAnonymous , Try like
Turnover OTC (Number) Spread orders current year vs. last year (Number) = CALCUALTE(SUM('Lian CH$Sales Invoice Line'[Quantity]),FILTER('Lian CH$Item','Lian CH$Item'[Item Group Code] = "A-Liste-C"))