Forum Discussion
Using date dim and filtering on different fact
Hello, I have a modeling problem I cannot seem to find a good approach for. I have two fact tables. One is for inspections conducted and another is actions, which are derived from within an inspec...
You can create and inactive relationship between DimDate and Actions the activate it in the measures, something like this.
Action Count =
CALCULATE (
COUNTROWS ( 'Action Table' ),
USERELATIONSHIP ( 'Action Table'[Action Date], Dim_Date[Date] )
)Here is an article on USERELATIONSHIP to help you out.
https://www.sqlbi.com/articles/using-userelationship-in-dax/
jdbuchanan71 Can you excplain how that would work in a standared table that shows attributed from both tables? i.e.
action id audit id action completed date action status inspection location
