topic Re: Count if in dax in DAX Commands and Tips

Count if in dax

amittal1 — Mon, 16 Sep 2024 07:45:06 GMT

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.

Re: Count if in dax

bhanu_gautam — Mon, 16 Sep 2024 09:49:24 GMT

amittal1 , Try using below DAX

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

Re: Count if in dax

amittal1 — Mon, 16 Sep 2024 15:07:00 GMT

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.

Re: Count if in dax

dharmendars007 — Mon, 16 Sep 2024 15:23:50 GMT

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

Re: Count if in dax

Anonymous — Wed, 18 Sep 2024 07:26:40 GMT

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.

Re: Count if in dax

amittal1 — Wed, 18 Sep 2024 07:43:53 GMT

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.

Re: Count if in dax

amittal1 — Wed, 18 Sep 2024 07:46:32 GMT

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.