Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

empty rows after creating relationships

Hi everyone,  I am using DirectQuery mode to access Catalog and ExecutionLogStorage table in reportServer database, in PowerBI. I filtered the Catalog table just for type=2, which shows just the rep...
Need Help
  • dax's avatar
    dax
    6 years ago

    Hi Anonymous , 

    I think you need to use measure and visual filter to achieve this goal.

    Measure = CALCULATE(COUNT(B[NAME]), FILTER(B,B[NAME]=RELATED(A[name])))

     

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous , Default is right to join , It means catalog do no have all the execution log storage has. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    amitchandak when I connect Catalog to ExecutionLog, it means : everything in Cataloga and matching rows from ExecutionLog, like qury below: 


    SELECT ca.Name, ca.Path,
    count(el.UserName) AS Uses,
    el.ReportAction
    FROM ExecutionLogStorage el
    JOIN dbo.Catalog ca ON el.ReportID=ca.ItemID
    where ca.type=2
    GROUP BY ca.name, el.ReportAction, ca.path

    ORDER BY count(el.UserName) DESC



    • dax's avatar
      dax
      Community Support
      6 years ago

      Hi Anonymous , 

      I think you need to use measure and visual filter to achieve this goal.

      Measure = CALCULATE(COUNT(B[NAME]), FILTER(B,B[NAME]=RELATED(A[name])))

       

      Best Regards,
      Zoe Zhi

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.