Dynamic Customer Facing Days Count based on date Range

[Anonymous]

Hi Experts

See link (sample data)

https://www.dropbox.com/s/aordvy5wxbmzdsg/sample.pbix?dl=0 

I want the value in the grey card to cout the number of Customer Facing days based on the date range Seleted - Current it is showing the count for all date periods.

For date range Week Start 10.01.2022 to 16.01.2022 i have 4 Customer Facing days 

For date range Week Start 17.01.2022 to 23.01.2022 i have 3 Customer Facing days 

irrespective of my Type Selection Criteria

Currently the grey box is showing 7 in as a total value and ignore's my data selected range...

[VIJAYKUMART]

hi, i hope this helps

Day Count = CALCULATE(COUNTROWS('FACT Table'),

FILTER(ALLEXCEPT('FACT Table','FACT Table'[Date]),

'FACT Table'[Type] = "Customer Facing Day"))+0

[Anonymous]

Hi Vijay - the Day count returns zero - which is incorrect

[VIJAYKUMART]

measure for gray color card: