Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Filter showing unexpected blank value

Hi guys,

 

i have a date filter which shows a blank value which shouldnt be there:

 

 

This is the setup:

 

Revenue table as basis and date table connected with it. No other relations. The date table is created with: 

 

Date = CALENDAR(MIN('PC Calculation'[dBezahlt]); MAX('PC Calculation'[dBezahlt]))
 
So the date table naturally encompasses all the dates that are prevalent in the revenue table.
 
To double check that all dates from the revenue table are also in the date table i created a custom column in the revenue table. In that column i look up the dates from the date table to check if any blank values are being produced. But there are none: 
 
 
Any ideas why the filter still shows a blank value? 
 
Thx!
 
  • Anonymous's avatar
    Anonymous
    6 years ago

    Ok it was a relation to another table that was inactive but still affecting the date table obviously. Solved!

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Ok it was a relation to another table that was inactive but still affecting the date table obviously. Solved!

    • v-easonf-msft's avatar
      v-easonf-msft
      Icon for Community Support rankCommunity Support

      Hi , Anonymous 

      It's pleasant that your problem has been solved, and thanks for sharing.

      Best Regards,
      Community Support Team _ Eason