Forum Discussion

Thim's avatar
Thim
Icon for Resolver V rankResolver V
7 years ago
Solved

Count.If from the same table

Hi All.   I have a general issue i hope you can help me with.   I have searched alot on how to make a Count.If function Using DAX.   So far i have found a way, if i am using two tables. As an ...
Need Help
Tips and Tricks
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi Thim

     

    I think maybe it's better to do that in Query Editor when the data is large. Here is the sample file for your reference.

     

    Regards,

    Cherie

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
7 years ago

Hi,

 

Why should the answer against Customer 1 be 8?  how have you computed that number 8?

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

Hi Ashish_Mathur

 

I think it's the count of  1 in 'Bill to costumer' column.

 

Regards,

Cherie