Column Results with '1'/'2' instead of 'True'/'False'

[ayeoh]

Hello again.

I created a column like this:

Category 1 = CALCULATE(SUM('Table'[Revenue]))>=4000000

and it results in a 'True' or a 'False'.

How can I modify this DAX so that instead of 'True' or 'False', it results in '1' or '2'.

Thank you!

[vicky_ · Accepted solution]

You can wrap the whole thing in an INT() to convert to a number (0 = false, 1 = true) and then do some maths if you need the numbers 1 and 2 specifically.