Forum Discussion
SoufTC
Helper I
Helper ICount 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: ...
SoufTCHelper I
Helper Ifirstly I would like to know if the measurements were well created : the number of reports per user and the number of reports per day worked then to know why the filter date does not work on the measurement report per day worked
https://drive.google.com/drive/folders/17DEqKseEVGO9Q62L5Titj4WDUgD5bCli?usp=sharing
Ashish_Mathur
Super User
Super UserHi,
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] )