Forum Discussion

theo's avatar
theo
Helper III
5 years ago
Solved

add multiple columns like countif

Hi,   I have 2 questions and this may have been discussed elsewhere but I can't find it. 1. what is the dax required to count each entry - like a countif.  see example below, target is Count_RC. ...
Need Help
  • theo's avatar
    theo
    5 years ago

    Hi v-janeyg-msft , thanks for the solution but as mentioned PQ's solution takes a while to complete for my data, so I modified the column expression mentioned initially to a measure instead since I found this tabular editor that can create multiple measures all at once.

     

    calculate(COUNTROWS(FILTER('28Jun_1973',[average diff]='28Jun_1973'[average diff])))

     

    Thanks for the help anyway.

theo's avatar
theo
Helper III
5 years ago

Hi v-janeyg-msft , thanks for the solution but as mentioned PQ's solution takes a while to complete for my data, so I modified the column expression mentioned initially to a measure instead since I found this tabular editor that can create multiple measures all at once.

 

calculate(COUNTROWS(FILTER('28Jun_1973',[average diff]='28Jun_1973'[average diff])))

 

Thanks for the help anyway.

v-janeyg-msft's avatar
v-janeyg-msft
Community Support
5 years ago

Hi, theo 

 

If you can find a solution that meets your own conditions, I'm very happy. Can you kindly mark the helpful answer as a solution if you feel that makes sense?

 

Best Regards

Janey Guo