Forum Discussion

harold191's avatar
harold191
New Member
7 years ago
Solved

cross matrix

I have a problem with a cross matrix. I need to count people who, being in a classification, are also in other classifications. Example Table Classification | IdPerson            A        |     ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

    Your expected result is wrong.  The answer for A/B and B/A should be 2 (not 1).  You may download my PBI file from here.

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
6 years ago

Hi,

I am willing to help you but i need to work with your file to know what the problem is.  Please share the file from your Home computer/another computer.  It actually will take quite some time for me to rebuild everything.

Thank you for your understanding.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    6 years ago

    Hi,

    Make the second relationship inactive.

    Hope this helps.

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        6 years ago

        You are welcome.  If my reply helped, please mark it as Answer.