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.
PowerBI Report Builder concatanate multirow text in chart
Hello, I have the bellow dataset, and i want to display it in a chart sort by "Dept" in row and "Level" in column but i want a specific column by "Dept" with my causes of all levels. Currently i succeed to sort by "Dept" and "Level" but my "Causes" column only show the level 2 causes. Did you now a way to aggregate the row of my dataset to display it in my chart ?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.Specific transformation on table
Hi Everyone, as you can see below, I have data in the format in the "Initial Table" that I'd like to transform to the ones in the "Transformed Table". Specifically, I'd like to group my data by order number but the resulting value should be a string in this format <Quantity><Product>-<Quantity><Product>-...-<Quantity><Product> But first sorted by Product. Is there a way to perform this in PowerBi in Power Query, please?
