Calender connected to data table and filter for date is removing data from visual

[Raj2410]

Hi I have a situation my summary table has multiple dates.

My calender table was created and added.

I connected calender date with summary tables work date.

The problem is when I go to visual shown below and filter January .

It filters out the equipments that don't have any date but I want to keep all 1324 equipment evern after month is filtered.

see belwo may be this will explain better.

[Raj2410]

@amitchandakTHANK YOU

I CREATED THE MEASURE AND ADDED IT TO MY VISUAL BUT I DONT THINK THIS IS WHAT I NEED.

I WANT TO KEEP ALL 1324 EQUIPMENTS IN THE VISUAL TABLE BUT THAT'S NOT HAPPENING SEE MY SCREENSHOTS BELOW.

[amitchandak]

@Raj2410 , Create a measure with removefilters or all

calculate(Count(Table[Column]), removefilters(Calendar))

Learn Power BI: All, allselected, removefilters,allexcept- https://www.youtube.com/watch?v=cN8AO3_vmlY&t=24270s

Also, refer HR approach to deal with multiple dates

Power BI: HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...