Unexpected behavior of calculated column
Hi community, we have a simple data model with tables order, order item and item. For statistical purposes we want to have the quantity sold for the item. If I add calculated column to article it works. If I then filter the visual by date from the order, that column is not filtered. Could anyone help to fix the problem, please? DAX: Verkaufte Menge = SUMX(RELATEDTABLE(tAuftragPosition), tAuftragPosition[fAnzahl]) Bye Magnus
DAX with double tables
Hello everyone, i have a MOM consumption data, I want to choose the month I want to analyse and the period "X" for which I want to compare ( last 30/60/90 days) "Y". All Dax works fine however if I want to get the value of only the new items for "X" compared to "Y", it compares it to the data in all the other months. I'm ready to clarify if needed. Thank you in advance.
Help w SumX using calculated column (multiplication)
Hi all I have a data model which Im using to calculate costs in an excel data model. Each employee is assigned a % they are on a scrum team. I have the daily rate for each employee and multiply that by % to get the adjusted daily rate. When I sum this column implicitly or explicitly with a measure I am getting the incorrect total for each scrum team. I am assuming I need to use SumX to get the correct total per scrum team however I cannot get it to work. The adjusted daily rate column multiplies % by daily rate. I need to sum this column to show all the scrum team rates by team and employee. The subtotal rows for each scrum team are not displaying correctly but the employee rows are correct. AdjDailyRate:=SUMX(Scrum__W_Rates,SUM(Scrum__Rates[Adjusted Daily Rate])) Example: the highlighted cell should equal 14,996.25. Thank youWriting Measure that Returns Customer Specific Revenue based on Customer Specific Multiplier
Hello, I am attempting to write a measure that examines the customer name before returning a customer specific revenue given a customer specific multiplier multiplied by the amount of items sold. For example, if the customer is customer 1 in this case, then we would take the customer 1 specific multiplier and multiply it by the number of items sold to get the customer 1 specific revenue (if customer = customer 1, then customer 1 multiplier * # of items sold = customer 1 revenue). However, the measure does need to be able to store multiple (up to 30) different customer specific multipliers and in turn know when to use each one based on filtering from a slicer that allows you to choose between customers. I have written the following measure that only appears to work for customer 1 and not the following customers in this example. The numbers 5, 10, and 15 are placeholder customer specific multipliers. Measure1 = SUMX (‘Table’, IF(‘Table’[Customer]= “Customer 1”, ‘Table’[Items Sold]*5, IF((‘Table’[Customer]= “Customer 2”, ‘Table’[Items Sold]*10, IF((‘Table’[Customer]= “Customer 3”, ‘Table’[Items Sold]*15 ….. Here is another measure I’ve attempted but have had no luck with: Measure2 = SWITCH( TRUE(), ‘Table’[Customer] = “Customer 1”, ‘Table’[Items Sold]*5, ‘Table’[Customer] = “Customer 2”, ‘Table’[Items Sold]*10, ‘Table’[Customer] = “Customer 3”, ‘Table’[Items Sold]*15, )) Any feedback and help are much appreciated.
