Forum Discussion
Lopez0090
Helper III
3 years agoDynamic Product Name Combinations and Display for Each Customer Using DAX in Power BI
■Goal: Create a DAX to dynamically combine the Items for each CustomerID and display each combination of Items and its proportion (count of CustomerID). ■What has been achieved: ・Creation o...
- 3 years ago
Hi, Lopez0090
You can try the following methods.
Column:Item Column = CONCATENATEX ( CALCULATETABLE ( VALUES ( 'Table'[Items] ), FILTER ( ALL ( 'Table' ), [CustomerID] = EARLIER ( 'Table'[CustomerID] ) ) ), [Items], "/" )Measure:
CustomerID_Count = CALCULATE(COUNT('Table'[Item Column]),ALLEXCEPT('Table','Table'[CustomerID],'Table'[Item Column],'Table'[Year]))Your original Measure needs no change.
Please see the attached.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.