Measure Issue counting days - to ignore slicer

[Invesco]

Hi Experts

See Sample file below 
https://www.dropbox.com/s/aordvy5wxbmzdsg/samplepbix?dl=0 

For the period selected 10.1.2022 to 16.1.2022 i have 4 Customer Facing days. When i select from the Filter (Type) f2f or Phone or Virtual I want the customer facing days number to remain as 4 in total for the selected Period. 

Currently then Measure "Day Count" in the grey box returns back zero. 

Day Count = Calculate(sum(FACT Table[Date Value]), Filter(ALL(FaCT Table), FACT Table[Type] = "Customer Facing Day"))+0 gives me the total customer facing days over the two week.....but i want to only return back Customer Facing Days over the selected date Period.

Cannot see the wood for the tree on how to resolve this...

[LuizLima00 · Accepted solution]

I 've a simple idea to resolver this.

You can create a table from dates and relate them, after that use mensure on bellow 

Remmember you must change the slicer for you new table of dates.

CALCULATE(
     SUM('FACT Table'[Date Value]),
    'FACT Table'[Type] = "Customer Facing Day"
) + 0

Hope this help, if not resolve you can tell me on my Linkedin here

[Invesco]

Hi LuizLima00 - Thanks for the excellent feedback but can you kindly post the PBIX with the solution please...