Forum Discussion
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
- AnonymousNot 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