Forum Discussion

SoufTC's avatar
SoufTC
Icon for Helper I rankHelper I
5 years ago

Count records using filter related tables

Hi everyone, I'm trying to build a dashboard that contains a date page filter and that calculates the number of reports per user and also per day worked. Here is the schema of my tables:   ...
Need Help
Tutorial Requests
SoufTC's avatar
SoufTC
Icon for Helper I rankHelper I
5 years ago

Hi DataZoe Still not working Thank's

 

Bof,

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
5 years ago

Hi,

Share the link from where i can download your PBI file.  In that file, show the problem and also the expected result.

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

      Hi,

      There should be a relationship from one of the Date columns of the Report_user table to the Date table.  Before, that you will have to remove the time stamp from the Date columns of the Report_user table.  Also, all relationships should have a Cardinality of Many to One and Cross filter direction of Single.  Lastly, the measure should be as simple as

      NUMBER OF REPORT = COUNT (REPORT_USER[ID_USER] )