Count if in dax

[amittal1]

Active_controlled = CALCULATE(COUNT('Sheet1 (2)'[placebo]), 'Sheet1 (2)'[placebo]=="Active-control trial")

This is my DAX formula  for measure Active_controlled that I have used, but its returning blank. I was trying to count the number of times Active-control trial is appearing in the column placebo in sheet - Sheet1 (2). Please help what can be done for this.

[bhanu_gautam · Accepted solution]

@amittal1 , Try using below DAX

Active_controlled = CALCULATE(
COUNT('Sheet1 (2)'[placebo]),
FILTER('Sheet1 (2)', 'Sheet1 (2)'[placebo] = "Active-control trial")
)

[Anonymous · Accepted solution]

Hi @amittal1 ,

I tested the measure of bhanu_gautam  and it works fine.
Here's my test data:

Output:

As dharmendars007 mentioned, did you apply a filter or did you use a slicer? You can create a table visual, place it on the same page as the card visual, and see if the output is correct.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[amittal1]

Hi @Anonymous , thanks for your care. I used a card for another value as well from the same column, may be that's the reason I am unable to do it for another value from the same column. So, I instead used slicer to show the total count. And, yes as you have tested bhanu's method I will mark it as an answer.

[bhanu_gautam · Accepted solution]

@amittal1 , Try using below DAX

Active_controlled = CALCULATE(
COUNT('Sheet1 (2)'[placebo]),
FILTER('Sheet1 (2)', 'Sheet1 (2)'[placebo] = "Active-control trial")
)

[amittal1]

Hi  bhanu, thanks for you answer, but this is again showing blank in the card. Just one thing to ask you, can we create more than one measure using a column, i think yes right, so I created this measure for the column values with placebo-control trial, that worked, but for active-control trial it didnt worked, dont know why.

[dharmendars007]

Hello @amittal1 , 

Please check if there is values for filter "active-control trial" in the table and also check if ther are any page level filters.

If you find this helpful , please mark it as solution and Your Kudos are much appreciated!

Thank You

Dharmendar S

LinkedIN 

[amittal1]

Hi @dharmendars007, thanks for your reply, I used a slicer instead, I think the problem was arising may be because I used a card already for another value(Placebp control trial) in the same column (placebo), and there might be something preventing me to use another card for the same column with different value.