How to compare three column and get repeated value detail for 1 particular column ?

[singhpratiksha8]

Need Help-  i have chassie no of vehicles , service type of vehicle and city .. i need output as if city changes for same chassie number, then it must come as "True",if not then "False" (service type could be anything ) in another calulated column .. i created calculated column as service_status_city .. But even after changing city its showing false only ... please let me know correct DAX for the same  e.g

[v-jiascu-msft · Accepted solution]

Hi @singhpratiksha8,

Try out this formula please. It can be a measure or a calculated column.

Measure =
IF (
    CALCULATE (
        DISTINCTCOUNT ( Table1[City] ),
        ALL ( Table1[Service type], Table1[City] )
    )
        > 1,
    TRUE (),
    FALSE ()
)

Best Regards,

Dale

[singhpratiksha8]

@v-jiascu-msft  Thanx i had solved it before only . request to help me with other query i just have posted at 3:34 pm (INDIA)