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 seems you have many date fields. What would you like to show it? In a visual or as a column? The formula is simple like below.

 

Measure = count('table'[DateField])

 

 

Best Regards,

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

Thank you for your reply.

 

The end goal is to have a CARD which COUNTS the TOTAL SUM of those selected.

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

    Hi LeighMacKay ,

     

    Did you try the formula I posted in my last reply? It seems the solution in your scenario.

    Measure = count('table'[DateField])

     

     

    Best Regards,