Forum Discussion

Brandonkersgoed's avatar
Brandonkersgoed
Frequent Visitor
4 years ago
Solved

Power BI/Dax Matrix

Hey Power BI Community, I'm struggling trying to put a matrix together, right now I have a table, I want to make a matrix showing a count with how many items are shown with eachother in each ID. T...
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi Brandonkersgoed 
    Please refer to attached file with the solution

    Measure = 
VAR Product1 = SELECTEDVALUE ( Filter1[Product] )
VAR Product2 = SELECTEDVALUE ( Filter2[Product] )
RETURN
    COUNTROWS (
        FILTER (
            'Table',
            CONTAINSSTRING ( 'Table'[Product], Product1 )
                && CONTAINSSTRING ( 'Table'[Product], Product2 )
        )
    ) + 0
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Hi Brandonkersgoed 
Please refer to attached file with the solution

Measure = 
VAR Product1 = SELECTEDVALUE ( Filter1[Product] )
VAR Product2 = SELECTEDVALUE ( Filter2[Product] )
RETURN
    COUNTROWS (
        FILTER (
            'Table',
            CONTAINSSTRING ( 'Table'[Product], Product1 )
                && CONTAINSSTRING ( 'Table'[Product], Product2 )
        )
    ) + 0
Brandonkersgoed's avatar
Brandonkersgoed
Frequent Visitor
4 years ago

Thanks tamerj1!

Worked exactly how I needed it to for my set.

Truly appreciate the help