Forum Discussion

Thim's avatar
Thim
Resolver 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

Thim's avatar
Thim
Resolver V
7 years ago

Hi All.

 

Thanks for all the suggestions and solutions.

 

At this point it does not look like this can be solved using only DAX without using the earlier function as well.

 

for now i will note Cheries answer as the solution, as i feel this gives the best solution to my problem.

This still requires two tables, but by mergin the tables, and then "Hide" the second table, does gives a quite nice result.

 

Thanks again all. :-)