Convert boolean to scalar value?

[edhans]

This might be a simple question but it is eluding me, short of a longer measure (which I have already created), is there a single function to convert boolean field to a scalar value?

For example, MIN and MAX can be used to convert text and number fields to a scalar value, and FIRSTDATE and LASTDATE will do the same for a date field, but MIN/MAX cannot be use on boolean (TRUE/FALSE) columns.

Scanning through the DAX functions isn't revealing anything.

I don't need a measure to do this. I've already done that. I just wondered if there was a single function to do this like there is for text, numbers, and dates.

[FrankAT]

Hi,

try:

TRUE() + 0 evaluates to 1

FALSE() + 0 evaluates to 0.

Regards FrankAT

[freder1ck]

INT ( TRUE() )

[edhans]

Hi @FrankAT 

I have a table that looks like this:

Date	Validated
1/1/2018	True
2/1/2018	False

If [Validated] was a text field, I could convert it to a scalar value by using the following measure:

Last Date Is Validated =
CALCULATE(
    MAX( TableName[Validated] ),
    LASTDATE( TableName[Date] )
        = DATE( 2018, 2, 1 )
)

That measure would evaluate to True() so I could do something else with that - an IF statement for example. MAX() converted the single record table for that field to a scalar value - or would if [Validated] was a numeric or alphanumeric field.

But MAX doesn't work on a boolean column, so that doesn't work. Trying to see if there is a single function that does work with boolean fields.

[v-jayw-msft · Accepted solution]

Hi @edhans ,

You can use SELECTEDVALUE() function instead of MAX() function.

Last Date Is Validated = CALCULATE(SELECTEDVALUE('Table'[Validated] ),FILTER('Table',LASTDATE('Table'[Date])=DATE(2018,2,1)))

Best Regards,

Jay

Community Support Team _ Jay Wang

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

[edhans]

Thank you Jay. SELECTEDVALUE() seems to be exactly what I was looking for in this instance.