calculate working days for the displayed table visual

[Anonymous]

Hi all, 

I have a table of employees with thier sector and a calendar table. On my calendar table i have a column which return 0 for Holidays and weekends and 1 for workings days. 

I created a mesaure for return total workingdays 

WorkingDays= 
SUM( _calendar[working Days] ) 

However when i place a visual table or matrix and add the employee names + the measure and then select a mesure in the slicer the table is not being filtered with the selected sector, it still showing all employees. Although when i remove the measure it shows all employees related to the selected slicer. 

Waht i am trying to achive is: 

If i have 2 employees filtered and the month is 22 days working days, on the visual table or matrix will display 22 for each and 44 as total working days.

Any thoughts? 

[Icey]

Hi @Anonymous ,

Is there a relationship between your two tables? Can you create a sample .pbix file for us to test? Please don't contain any real data and sensitive information.

Best regards

Icey

[Anonymous · Accepted solution]

Hi I found a soluction. 

I just created a second measure: 

WorkingDays2= 
Calculate( Values(calendar [Month]), workingdays)