Forum Discussion

Richard_Halsall's avatar
Richard_Halsall
Helper IV
1 year ago

Count Record Measure on Dimension Table for Matrix Visual

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

Need Help

1 Reply

  • audreygerred's avatar
    audreygerred
    Super User
    1 year ago

    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.