Forum Discussion
Incorrect data represented when using multiple date tables and filters
Hello, My PowerBI dashboard is to represent the number of submissions that an assigned tech is either in a CLOSED or OPEN state. this report is based on a single table with both Created and Closed ...
I have created a non aligned datetable and then created seperate relationships with a CLOSED Datetable and OPEN Datetable that are linked to the CREATED and CLOSED date fields in the VariableData table which has the information. That is not a recommended approach. Have a single dates table, connect it to the Open Date with an active relationship and to the Close Date with an inactive relationship. Then create your measures , using USERELATIONSHIP for the close measure.
Ok, I'm fairly new to the USERELATIONSHIP dax coding. how would I go about doing this?