Forum Discussion
mlozano
Helper III
Helper IIISUMIFS in DAX
I am trying to create a sumifs in DAX using the CALCULATE function which has as an expression a measure that calculates the ACT volume share percentage of each SKU ID over the total ACT volume. The i...
Dhacd
Resolver III
Resolver IIIGood Day mlozano,
From the source data, you have shared I have created a small sample data and calculated the sumifs for it screenshot attached below. If your desired output is the same the calculated column formula is attached below.
Use the below formula for the output.
sumifs = calculate(Sum('Table'[Peso SKU Act])
,FILTER('Table',EARLIER('Table'[Month])='Table'[Month])
,FILTER('Table',EARLIER('Table'[Month])='Table'[Month])
,FILTER('Table',EARLIER('Table'[Category])='Table'[Category]))
If you think this helps you mark this as a solution.
Thanks and regards,
Atma.