Forum Discussion

mlozano's avatar
mlozano
Icon for Helper III rankHelper III
4 years ago

SUMIFS 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...
Need Help
Dhacd's avatar
Dhacd
Icon for Resolver III rankResolver III
4 years ago

Good 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'[Category])='Table'[Category]))


If you think this helps you mark this as a solution.
Thanks and regards,
Atma.


  • mlozano's avatar
    mlozano
    Icon for Helper III rankHelper III
    4 years ago

    Hi, thanks for your response. Maybe as a calculated column it works, but as a measure it doesn't, it must be a measure, that's why I try to force the row context so that it doesn't always add up to 100%. The calculated column keeps static values, they are not recalculated based on filters applied on the report.

    • Dhacd's avatar
      Dhacd
      Icon for Resolver III rankResolver III
      4 years ago

      Which visual are you trying to create this measure for?
      And what all are the slicers on the page?

      • mlozano's avatar
        mlozano
        Icon for Helper III rankHelper III
        4 years ago

        Hello, I want to build a bar chart, which is filtered by Category and Price Segment column, initially, but it should be possible to filter by any dimension of the data table and the result should be as expected.

         

        without filters

         

        With Channel Detail and price segmnet filters

         

        The result of the sumifs must not be a percentage, it must be in decimals