Calendar table issue when using filter days

[Syndicate_Admin]

Dears: good afternoon, and good year to all, I write to see if someone can give me a help, since I am having a problem after making the relationship between the calendar table and the table that has the data:

I am creating the calendar table as follows:

CALENDAR RESOLVED = ADDCOLUMNS(CALENDAR (MIN(Resolved[Resolved]), .MAX(Resolved[Resolved])),

"NUMBER MY", FORMAT ([Date], "MMMM"),

"MES", MONTH([Date]),

"YEAR", YEAR([Date]),

"DAY", DAY ([Date]),

"YEAR MONTH NUMBER", FORMAT ( [Date], "YYYY/MM" ),

"NUMBER DAY WEEK", WEEKDAY ( [Date],2 ),

"NUMBER WEEK", WEEKNUM([Date],1),

"WEEK DAY", FORMAT ( [Date], "dddd" ),

"QUARTER", "Q" & FORMAT ( [Date], "Q" ),

"QUARTER OF THE YEAR", FORMAT ( [Date], "YYYY" ) & "/Q" & FORMAT ( [Date], "Q" )

)

At the time of making the relationship with the table where the data are, there is no problem, but when I want to make a query of a certain date, it shows me the following:

IN THE FILTER DAYS A BLANK FIELD, WHICH MO EXISTS IN THE DATA TABLE AND THE DAYS I HAVE LOADED WITH DATA, WHEN I WANT TO SEE THE INFORMATION ONLY SHOWS WITH THE FIELD THAT SAYS WHITE AND WITH THE OTHERS DOES NOT SHOW ME ANYTHING.-

That happens with the white filter

This happens when I use a certain date.-

I fixed the measures for the doubts that have some error and are correct, but this today I surpass myself.-

Someone could tell me where I'm doing wrong.-

Sdos.

John Paul

[amitchandak]

@Syndicate_Admin , Blank means there are some missing values in date table or it joining with table have blank values in date table

refer

https://www.youtube.com/watch?v=23qemkDqMVY

https://www.encorebusiness.com/blog/blank-value-in-the-power-bi-slicer-and-filter/