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.

lbendlin's avatar
lbendlin
Super User
3 years ago

To report on things that are not there you need to use disconnected tables (with your week numbers) and crossjoins or measures.

 

Please provide sanitized sample data that fully covers your issue.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523