Forum Discussion

LeighMacKay's avatar
LeighMacKay
Icon for Helper I rankHelper I
7 years ago
Solved

Create a count measure which work with filters

Hi All,   Can anybody advise how I create a measure which counts a date & time field? If the date and time field does't exist (NULL) then don't count it. If the Date & Time field has any entry, ...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    Hi LeighMacKay ,

     

    It does work with filters. If you want to remove the impact of filters, you can use ALL in the formula like below.

     

    Measure = calculate(count('table'[DateField]), all('table'[field]))

     

     

    Best Regards,

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi LeighMacKay ,

 

It does work with filters. If you want to remove the impact of filters, you can use ALL in the formula like below.

 

Measure = calculate(count('table'[DateField]), all('table'[field]))

 

 

Best Regards,

LeighMacKay's avatar
LeighMacKay
Icon for Helper I rankHelper I
7 years ago

This now works.  Great stuff and thank you for your help