topic Re: DAX Measure IF AND with multiple conditions in DAX Commands and Tips

DAX Measure IF AND with multiple conditions

tomkribi — Fri, 23 Oct 2020 09:02:39 GMT

Can anyone help me with the following;

Measure =
IF (
    AND (
        CONTAINS (
            'table1',
            'table1'[FID_Custom], "TRUE"
        ),
        CALCULATE (
            CONTAINS (
                'table1',
                'table1'[Status], "Validated"
            )
        )
    ),
    1,
    0
)

=> I want to get all rows with 'table1'[FID_Custom]"TRUE" and 'table1'[Status] "Valiated" => currently I get only the "TRUE" once.

It is a IF condition with multiple selections.

Many thanks

Re: DAX Measure IF AND with multiple conditions

Pragati11 — Fri, 23 Oct 2020 09:20:49 GMT

Hi tomkribi ,

There is a simpler way of writing your IF statement: (Create a caluclated column)

calcColumn = IF('table1'[FID_Custom] = "TRUE" && 'table1'[Status] = "Valiated", 1, 0)

If this doesn't help post some sample data and desired output.

Thanks,

Pragati

Re: DAX Measure IF AND with multiple conditions

AlB — Fri, 23 Oct 2020 09:25:34 GMT

Hi tomkribi

Try

Measure = CALCULATE ( COUNT ( 'table1'[FID_Custom] ), 'table1'[FID_Custom] = TRUE (), 'table1'[Status] = "Validated" )

if FID_Custom is of Boolean type. Or:

Measure = CALCULATE ( COUNT ( 'table1'[FID_Custom] ), 'table1'[FID_Custom] = "TRUE", 'table1'[Status] = "Validated" )

if FID_Custom is of text type.

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers

Re: DAX Measure IF AND with multiple conditions

tomkribi — Fri, 23 Oct 2020 09:45:44 GMT

Great, many thanks, this is the solution for me

Measure =
CALCULATE (
    COUNT ( 'table1'[FID_Custom] ),
    'table1'[FID_Custom] = "TRUE",
    'table1'[Status] = "Validated"
)