Forum Discussion
How to sum a filtered field
Hi, Im having the following problem. In the graphs you can see the values by all the products and in the table below its values by product: The values by product (table) are perfec...
AllisonKennedy
Community Champion
Community ChampionAnonymous This is a challenge for DAX context. You need to put the product row filter into your DAX measure.
Try something like this:
Volume Impact (non recurring) =
SUMX(VALUES(Product[Name]), IF([Net Net Amount CY] < 0,[Spend Delta Absolute],0) )