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
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.