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

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

 

  • v-zhangti's avatar
    v-zhangti
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi, mlozano 

     

    Can you explain how you got the 1.87 at this point? I've filtered and the sum of the Peso SKU Act column should be 1.87 at this point.

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

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

      Hello, thanks for your answer, you mean how the SUMIFS was built from excel to obtain 1.87 as a result.