Forum Discussion

Lopez0090's avatar
Lopez0090
Icon for Helper III rankHelper III
3 years ago
Solved

Dynamic 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...
  • v-zhangti's avatar
    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.