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 ,

 

Could you please mark the proper answers as solutions?

 

 

Best Regards,

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

    Hi,

     

    The solution that you have responded with works.  But not in the nature which I require.

     

    It doesn't work with the filter, but the total only at all times.

    • 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