Forum Discussion
Help Needed: Creating Separate Response Count Matrices in Power BI
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])
)
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.
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])
)
