topic Re: Help with DAX coding, to count the number of "TRUE" in DAX Commands and Tips

Help with DAX coding, to count the number of "TRUE"

Womble23 — Sat, 12 Aug 2023 10:32:51 GMT

Hi,

I have table of 15 columns where some, all or none of the columns may have a TRUE in 1 or more of the columns.

I'm looking to create a calculated column which shows me the number of "TRUE" per row with the answer in each row being 0, or 1 - 15.

From my research I understand I need to use a logical test as I'm using True and False values . I've also thought of changing the TRUE/FALSE format to whole numbers but we already have other filters set up for the TRUE/FALSE set up so I would rather leave them as TRUE/FALSE.

is COUNTAX the function I should be using?

Thanks

Re: Help with DAX coding, to count the number of "TRUE"

Womble23 — Sat, 12 Aug 2023 17:11:59 GMT

I have searched for other examples but can only find one's that start like this:

I'm also not sure if I can add 15 columns all inside one set of brackets? is that too many?

Any help would be really appreciated.

Re: Help with DAX coding, to count the number of "TRUE"

Womble23 — Sat, 12 Aug 2023 18:04:57 GMT

So after more hours of searching I came across an example which was similar to mine so I copied the code and tried to amend it

sadly this is giving me a repeative number of 281 in every cell.

I was expecting to see this result - what am I doing wrong?

If anyone has any advice I'd be really grateful

Re: Help with DAX coding, to count the number of "TRUE"

tamerj1 — Sat, 12 Aug 2023 18:21:03 GMT

Hi Womble23
You can simply sum the 15 columns

Re: Help with DAX coding, to count the number of "TRUE"

Womble23 — Sat, 12 Aug 2023 18:25:16 GMT

Thanks for your help. I got to the answer just before you posted! My way was much more complicated but hey I learnt a few new things today. So much to learn! thanks again. 🙂