DAX Function to Concatenate Distinct Values from a Dimension Grouped by a Different Dimension Column
Hello, Looking for the Community's help on this. I have the below data model. I want to create a column with DAX to concatenate product categories form DimProduct by the Employee to show all the categories that this employee sold. What I got from CONCATENATEX is repeated values and blank values of categories an Employee did not sell. Appreciate your help on this. Desired Outcome: Employee First Name Employee Last Name Categories Sold John Doe A, B, C, D Jane Doe B, C Lord Voldemort D Severus Snape A, C EDIT (26-10-2023): I am trying to create this a DAX column in the DimProduct table.DAX Measure to concatenate common values found in more columns
Hi Community, I'm working with a table structured as follows: I would like to write a DAX measure that returns in any row a unique string of combination of Column_1 and Column_2 values that belongs to both columns. For example, if I put a slicer selector on Blue, the visual should return the following: Values "200" and "450" are not part of the concatenation because they only appear on Column_2. And, if I turn the slicer on Yellow, it shall return: Again, values "200" and "450" in Column_2 do not become part of the Concatenation, since are not common to both columns. In other words, I'm trying to figure out how to write a measure that repeat the same combination in any row of the row context [regardless the row] and is filtered by the field context based on Column_3. I do appreciate your kind suggestions! Marco.
Data from one or another column but merged
Hi, I have two columns with the same name (Business Region) in two entities (contact and account) If it s a contact then Business Region from contact is populated and Business region from Accoutn is blank and the way around. CONCATENATE = SELECTEDVALUE(account[Business Region]) & SELECTEDVALUE(contact[Business Region]) I need basically to concatenate the data. Also to mention is direct query not import of data. Can you help please. Thank you More details: So we have 3 entities: contact, account and donation. When the amount from donation is linked to contact (so it's a person who donated) then it is populating the Business Region for contact but is blank for account. And when the donation is coming from an account (a business/organization etc) the business region is populated for account entity and is blank for contact. I basically need to get those two fields of Business Region populated in one field. So as example let s say: Jon Doe donated 6 euro and he is from London (only contact Business Region field is populated as this is contact) and Analytics ISO company donated 7 and location is Belfast (only account Business Region field is populated as this is account) My output should be: Donor Business Region Amount Jon Doe London 6 Analytics ISO Belfast 7 Hope now makes sense.
Switch / Case multiple results
Hello all, I'm attempting to make an "error message" column in a table that can read multiple criteria and result the reasons there's an error message for the given project (rows in the table). I've found that Switch( True(),... ) only wants to find one criteria but I have overlapping cases where more than one case is true. Here's generally what I've got so far: Error Message = SWITCH( TRUE(), 'Data'[Start_Date]=BLANK(),"Start Date is blank", 'Data'[Status]="Red","Status is Red", //among several dozen other columns "No Errors") What's my alternative since if/elif doesn't seem to be availabile in dax? Any ways to cycle back through the cases? Ultimately I'd like to find a way to concatenate the various error messages with commas into a single column (per row) in a table. Any ideas from the community? Thanks.
