Forum Discussion

Maleninx's avatar
Maleninx
New Member
3 years ago

Total with sumx and more variables

Hello,

I need your help to calculate the total of a deviation.
I have three tables, the main one is the sales table, another one is the product table and another one is the customer table.

In the sales table, I have everything related to the income with the quantities sold, with several filters we have the quantities sold vs the budgeted for certain customers and certain products.
I am trying to get a deviation in the sales price vs what was sold, and I just want a function to help me find the price deviations, where I have sales with the budget (marked in green), however, the functions give me the total.
I have applied the DAX with
sumx ( filter('Product', [Sales] >0 && [Budget]>0 ),calculate([Quantity] * [Dev] ) )

But it doesn't work, it makes me the groupings by customer of his budget and his real sales, when I need the filter by customer and product.

 

 

 

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Maleninx ,

    I'm a little confused about your needs, Could you please explain them further? It would be good to provide a screenshot of the results you are expecting and desensitized example data.

    Thanks for your efforts & time in advance.

     

    Best regards,
    Community Support Team_Binbin Yu