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
Icon for Super User rankSuper User
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.

  • JasonLorneGiles's avatar
    JasonLorneGiles
    Regular Visitor
    6 years ago

    Hi Anish,

     

    I downloaded your file and tried to make a matrix with your data right next to the one provided it and I get a "Can't display the visual" error. I have it set up the same way as yours in the same file too. Image of the Error 

     

     

    Any idea what I am doing wrong?

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      6 years ago

      Hi,

      Click on the Format icon in the visualisation pane and remove all totals.

  • RanjanThammaiah's avatar
    RanjanThammaiah
    Icon for Helper V rankHelper V
    6 years ago

    Ashish_Mathur Can you please help me the below case.

     

    I have tried the same like you have mentioned. Not sure why i am getting only the Zeros. Am i missing something from this?

     

    Sample data

    SSLUDN
    BTS1011471332
    PAS1011471332
    PAS1011471335
    BTS1011471332
    BTS1011471335

     

  • RanjanThammaiah's avatar
    RanjanThammaiah
    Icon for Helper V rankHelper V
    6 years ago

    Ashish_Mathur Could you please help me to resolve the same data.

     

    Not sure if i have recreated the same way you did. but i couldn't get the exact result as you have got.

    For sure i am missing something. Could you please help me.

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      6 years ago

      Hi,

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

      • RanjanThammaiah's avatar
        RanjanThammaiah
        Icon for Helper V rankHelper 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