DAX Measure IF AND with multiple conditions

[tomkribi]

Hi

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

[AlB · Accepted solution]

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 

[AlB · Accepted solution]

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 

[tomkribi · Accepted solution]

Great, many thanks, this is the solution for me

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

[Pragati11]

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