Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Count using filters

Hi,   I have this measure -   C/F Closed = CALCULATE(DISTINCTCOUNT([ClientRef]),[Carried Forward] = 1,ClientsList[EndDate] >= DATE(2019,1,1))   error is: A function 'CALCULATE' has been used ...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi,

     

    I created a little mock dataset that looks like this:

     

    As you can see from the data, three Client Refs meet the criteria you've listed (1, 3, 9). I created the following calc that seemed to work for me:

     

    C/F Closed = COUNTX( FILTER (FILTER ( ClientsList, ClientsList[Carried Forward] = 1 ), ClientsList[End Date] >= DATE(2019,1,1)), ClientsList[Client Ref])
     
    It outputs 3, as expected:
     
     
    Let me know if this works for you.
     
    Thanks,
    Ben

     

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi,

 

I created a little mock dataset that looks like this:

 

As you can see from the data, three Client Refs meet the criteria you've listed (1, 3, 9). I created the following calc that seemed to work for me:

 

C/F Closed = COUNTX( FILTER (FILTER ( ClientsList, ClientsList[Carried Forward] = 1 ), ClientsList[End Date] >= DATE(2019,1,1)), ClientsList[Client Ref])
 
It outputs 3, as expected:
 
 
Let me know if this works for you.
 
Thanks,
Ben

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

That's great Ben. Thanks alot.