Help Needed: Creating Separate Response Count Matrices in Power BI

[ReneeKoelewyn]

Hello everyone,

I hope you're doing well!

I'm looking for guidance on how to create a matrix in Power BI that counts responses for different questions. I tested it with two questions that had the same dropdown options, but I'm also interested in creating a separate matrix to summarize responses to "rate your experience" questions.

Currently, when I create the matrix, I'm seeing the same total for both questions. I've tried setting up a bridge table (as shown in the image below) and established a one-to-many relationship, but I'm still encountering issues.

Any help or insights would be greatly appreciated!

Thank you!

Bridge table:

 Relationship:

[ReneeKoelewyn]

Thank you. I suspect something might be wrong with how I set up the bridge table because it keeps pulling through the first measure results...

[Angith_Nair]

Hi @ReneeKoelewyn 
Create two one to many relationships between the main table and the bridge table. One will be an active and other will be an inactive relationship. Plot the column from Bridge table in the matrix just like you did and the below measures.

Create two measures:

M1 = COUNT (24Registration[Rateyourexp])

M2 = 
CALCULATE(

COUNT (24Registration[How did you exp]),

USERELATIONSHIP(BridgeTable[IncorrectResponse], 24Registration[How did you exp])

)

Make sure that in USERELATIONSHIP, you use the columns on which the relationship is inactive.

Please accept this as a solution if you find it helpful.

[ReneeKoelewyn]

Hi @Angith_Nair ,

Thank you. However, I get the following error. Do you know what I am doing wrong?

[Angith_Nair · Accepted solution]

@ReneeKoelewyn 

In Line 2, you need to close the paranthesis of COUNT (). I have bolded the paranthesis below. 

CALCULATE(

COUNT (24Registration[How did you exp]),

USERELATIONSHIP(BridgeTable[IncorrectResponse], 24Registration[How did you exp])

)