Forum Discussion

devesqdeves's avatar
devesqdeves
Helper II
3 years ago
Solved

Filtering by Week but to show NULL values

Hello! I am trying to filter a visual by Week but to get the values that have nulls in EndDate. The 2 tables here presented have a 1-Many relationship, between EndDate(ConsultantStateTable ) and Da...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    3 years ago

    Hi devesqdeves 

     

    Since you need to compare StartDate and EndDate with the calendar dates at the same time, you need to break the relationship between ConsultantStateTable and Date table. With the current relationship between EndDate(ConsultantStateTable ) and Date (Date), NULL EndDate value cannot match any date in Date table, so it is filtered out when you select a week. You have to remove the relationship and keep two tables disconnected. Then the measure should work. 

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

v-jingzhang's avatar
v-jingzhang
Community Support
3 years ago

Hi devesqdeves 

 

Since you need to compare StartDate and EndDate with the calendar dates at the same time, you need to break the relationship between ConsultantStateTable and Date table. With the current relationship between EndDate(ConsultantStateTable ) and Date (Date), NULL EndDate value cannot match any date in Date table, so it is filtered out when you select a week. You have to remove the relationship and keep two tables disconnected. Then the measure should work. 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.