Custom total value for measure
Hi, I'm trying to get a specific total value, but I'm not sure how can I achieve it. So I've got two variables "Densidade" and "FX Quimicos". The way my deviation formula works, I can get the total for one or the other, depending on which is being filtered on the slicer. The thing is I want the total also when both are being selected, but the total needs to be the sum of the individual values of each variable. Example below: File: https://we.tl/t-i40oiGDkRJ My total for "Densidade" deviation is -1,11%: My total for "FX Quimicos" deviation is -0,11%: My total value of both variables should be -1,11% + (- 0,10%) = -1,21% I have not been able to get that total of the both variables. Tried summarize but still not working. Could you please help me in this? Thank you Best regards, André
Discount per Customer and SKU
I have a Table named "Descuentos Escalas" where I have a discount per each Customer, Client and SKU. The discount is applied y som conditions as reached by the customer. I created this DAX formula to bring the Discount. I have to evaluate the condition per Quater, it is a quater discount. I could bring the Discount ( Columns GTN) but the problem is that the discount is being applied per month and the final GTN obtained is the maximun between the three months of the Quater. I used this DAX formula because I could not obtained total, and that was my way to have a total discount.measure is not showing total value in table visual
hi everyone i have created a measure that calculates sales agents commission based on his achievment % for each sales category. when i added the measure to a table visual, it's showing the the total value of the table visual as 0 instead of summing the commission values for each category. the total for measure 'new commission calculation' shoulde be 660 instead of 0 and the total for measure 'new agent incentive' should be 225 instead of 0Two Grand Totals in Matrix Visual based on some conditions
Hi All, I am trying two create a simple matrix visual where I would like to show two grand totals at the end of the matrix. The first grand total (total) is the overall sum of all the rows and another would be the sum based on some conditions, In the below data first total is the overall total, and the second total is where the quantity is 100 FYI - This is just sample data I am looking to apply this logic in a big matrix where I have to calculate the total based on certain values (sum where value is 1 or 2). I have tried several ways but unable to achieve it. Anyone, please help me with this. Data and expected output: Person Salary A 100 B 200 C 400 D 100 E 100 Total 900 Total(100) 200 Your quick support will be highly appreciated. Regards Uphar
