Forum Discussion

DominicBrien's avatar
DominicBrien
Frequent Visitor
9 years ago

Count related items

Hello, I have a quite basic scenario (in Direct query) but I cannot find a basic solution for it.   It only involves 2 tables and a relation between the two.   Lets say I have a Person table and ...
Need Help
cs_skit's avatar
cs_skit
Resolver IV
9 years ago

I don't exactly get what you need. Your data table seems to suggest 1 Case only has 1 subject?

 

Or does a case have multiple subjects because thats what the result you need seems to suggest?

  • DominicBrien's avatar
    DominicBrien
    Frequent Visitor
    9 years ago

    Hello, a case always has a single subject.

    What I am looking for is how many subject have 1, 2, 3 etc cases as per last table.

    I can do it with a Group by but I have a problem when I try to apply filters using the date field...

     

    • cs_skit's avatar
      cs_skit
      Resolver IV
      9 years ago

      To solve it I had to create a new table with this DAX:

      then you can do this:

      Didn't get it to work quickly without the extra table I don't use SUMMARIZE often.

      Maybe you can figure out if you can do it without the extra table but this works.

      • DominicBrien's avatar
        DominicBrien
        Frequent Visitor
        9 years ago

        Hello, were you able to to this in direct query mode? My understanding was that table creation was not enabled in direct query mode...

        What you did does a simmilar result to what I get with group by but I would also have an issue when attempting to filter on the date of cases.

         

        Regards,