Sum true value in dax

[Sathvik123]

Hello All,

I have field where its having values true / false.

I need to sum if we have value true.

So I created a column like below and after that create a measure to sum this but not working.

X= IF('Table'[Breached?]=TRUE,1,0)

Measure = sum(X)

Any help please

[ryan_mayu · Accepted solution]

@Sathvik123 

it should work

does the DAX formula for X column work?

pls see the attachment below