Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Dynamic Customer Facing Days Count based on date Range

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...

 

 

Need Help

3 Replies

  • VIJAYKUMART's avatar
    VIJAYKUMART
    Resolver I
    4 years ago
    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's avatar
      Anonymous
      Not applicable
      4 years ago

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