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

[Womble23]

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

[tamerj1 · Accepted solution]

Hi @Womble23 
You can simply sum the 15 columns 

[Womble23]

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. 🙂

[Womble23]

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 

[Womble23]

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.