Count Record Measure on Dimension Table for Matrix Visual

[Richard_Halsall]

Hi 

Struggling to resolve this requirement

My Data model is as shown

I have a Date Slicer (from Dates) & Project Name Slicer (from DimProject)

In the matrix visual I have the Date and I am attempting to write a measure that counts the number of records in the DimJobTasks table when a specific Project Name is selected in the slicer but this table only has a relationship with the FactTimesheet table and I am struggling

Any help or advice would be much appreciated

Thanks

[audreygerred]

Hi! Do tasks belong to Projects? If so, assuming the task list has the Project ID, you could create a snowflake schema - join Project to Task and Task to fact. Then, Project will filter Tasks and Tasks will filter Fact.