Forum Discussion

tutoteca's avatar
tutoteca
New Member
8 years ago

count.if in dynamic range

Hi,

 

i want to know if it's possible to do this in DAX

 

=count.if($C$2:C2,D2)

 

the range is dynamical and increases when go down.

 

thanks a lot

3 Replies

  • v-caliao-msft's avatar
    v-caliao-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    tutoteca,

     

    The count if logical in exlce is not the same as in DAX, if you provide us some sample data and elaborate your expected result. we could make further analysis. Do mask sensitive data before uploading.

     

    Regards,
    Charlie Liao

    • tutoteca's avatar
      tutoteca
      New Member
      8 years ago

      Hi,

       

      i want to know if its possible to do this in DAX:

       

      =count.if($C$2:C2,D2)

       

      The range is dynamical and increases when go down.

       

      (i beg your pardon for my english that is not so good)

       

      Thanks a lot