Forum Discussion

milo's avatar
milo
Frequent Visitor
6 years ago
Solved

Matrix count showing same number for each column

Hello,   I made a matrix using a count of a field from my database. This is what it looks like:     As you can see, each column has the same number for each row. I exported the data and ma...
Need Help
mwegener's avatar
mwegener
Most Valuable Professional
6 years ago

Hi milo ,

 

could you post a screenshot of the model view?

 

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.

milo's avatar
milo
Frequent Visitor
6 years ago

Hello Marcus,

 

I do not see a model view in my version of Power BI. I have added a screenshot of my relationship view:

 

 

  • mwegener's avatar
    mwegener
    Most Valuable Professional
    6 years ago
    Hi milo,
    as you can see in the screenshot, the service table (column) does not filter the manifest table (value).
    • milo's avatar
      milo
      Frequent Visitor
      6 years ago

      Hi mwegener 

       

      This is how my filters are set up:

       

       

      The mf_end_del_dt filter is coming from the manifest table. No filter is being applied from the service table. Are you suggesting that there should be?

      • mwegener's avatar
        mwegener
        Most Valuable Professional
        6 years ago

        Hi milo ,

         

        the column "sv_reason" tries to split (filter) the value, but the relationship does not work in this direction.