topic Re: Dax Calc countif in DAX Commands and Tips

Dax Calc countif

Anonymous — Mon, 28 Nov 2022 16:25:19 GMT

I need help figuring out how to write this formula in dax.

COUNT IF [F RETAIL FH FIRST/FURTHER] = "FIRST" OR "FURTHER"

Re: Dax Calc countif

ERD — Mon, 28 Nov 2022 16:58:06 GMT

Anonymous ,

You can try the measure below:

your_measure = IF ( 'F RETAIL FH FIRST'[FURTHER] IN { "FIRST", "FURTHER" }, COUNT ( 'F RETAIL FH FIRST'[FURTHER] ) )

Re: Dax Calc countif

Anonymous — Mon, 28 Nov 2022 17:33:55 GMT

Thanks for the answer, but that syntax does not work.

Re: Dax Calc countif

ERD — Mon, 28 Nov 2022 17:35:25 GMT

What's the error?

Re: Dax Calc countif

Anonymous — Mon, 28 Nov 2022 18:41:11 GMT

I dont think and if will work for dax. I am just looking to COUNT [F RETAIL FH FIRST/FURTHER] when its = to "FIRST" OR "FURTHER"

Re: Dax Calc countif

ERD — Mon, 28 Nov 2022 19:59:51 GMT

Ok, here is another option:

your_measure = CALCULATE ( COUNT ( 'F RETAIL FH FIRST'[FURTHER] ), 'F RETAIL FH FIRST'[FURTHER] IN { "FIRST", "FURTHER" } )

Re: Dax Calc countif

Anonymous — Mon, 28 Nov 2022 20:46:20 GMT

Thats not getting me the answer I need. below is the calc I am trying to convert from qlik to pbi. The RTL_First_further is text if that helps.

sum(if(RTL_FIRST_FURTHER = 'FIRST',1,
if(RTL_FIRST_FURTHER = 'FURTHER' ,1,null())))

Re: Dax Calc countif

Anonymous — Tue, 29 Nov 2022 08:38:53 GMT

Hi Anonymous ,

What is the logic you are trying to convey?

My idea: This is your filtering criteria F RETAIL FH FIRST[FURTHER] = "FIRST" or "FURTHER".

When this condition is met, you need to count or sum some data? Is this what you have in mind?

Best regards,

Community Support Team Selina zhu

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

Re: Dax Calc countif

Anonymous — Tue, 29 Nov 2022 15:10:18 GMT

Hi,

Yes that is exactly what I have in mind. I just need the sum of F RETAIL FH FIRST[FURTHER] after the condition is met, but I have diffucutlties because it is text.

Thanks.

Re: Dax Calc countif

Anonymous — Wed, 30 Nov 2022 09:28:42 GMT

Hi Anonymous ,

Text is not computable for aggregation, I think you need to convert the data type first.

Through here to change the data type:

and then you can do some calculation.

Refer to my pbix file for better understanding.

Best regards,

Community Support Team Selina zhu

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