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,

Share the link from where i can download your PBI file.

RanjanThammaiah's avatar
RanjanThammaiah
Helper V
6 years ago

Hi Ashish_Mathur Unfortunately my organisationdoesn't allow to share the content(Blocked).

 

I have used the same kind of data and the columns as it in your file. But not suse am i missing something from it.

I could see only the 0 for the cross reports.

May i please ask you to build one Pbix file for the data i have shared.

 

Sorry!

 

Regards,

Ranjan

  • 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.