Dax query to count unique values in a column by comparing it with other column

[madhav2020]

Hey folks,

Need your help with a query.

Here goes the problem definition,

Below table has ID column with unquie values and the corresponding Risk factor column which has same/different values.

Now expected output will be to check if values in Risk Factor column is changing wrt ID and if does then expected ouput will be 1 and if not then 0 as shown below.

Risk	OID	Expected output
11.0	21445.34552.17462.60490	1
75.3	21445.34552.17462.60490
73.6	21445.34552.17462.60490
72.5	21445.34552.17486.61667	0
11.0	21445.34552.17510.33157	0
11.0	21445.34552.17510.33157
0.0	21445.34552.17511.36651	0
0.0	21445.34552.17511.36651
0.0	21445.34552.17511.36651
0.0	21445.34552.17511.36651
0.0	21445.34552.17511.36651
0.0	21445.34552.17511.36651
0.0	21445.34552.17511.36651
0.0	21445.34552.17511.36651
81.1	21445.34552.17558.59465	1
76.4	21445.34552.17558.59465
0.0	21445.34552.17608.42491	0
0.0	21445.34552.17608.42491
0.0	21445.34552.17608.42491
100.0	21445.34552.17637.32864	0
100.0	21445.34552.17637.32864
42.3	21445.34552.17689.35090	0

[AlB · Accepted solution]

Hi @madhav2020 

New column =
IF (
    CALCULATE ( DISTINCTCOUNT ( Table1[Risk] ), ALLEXCEPT ( Table1, Table1[OID] ) ) > 1,
    1,
    0
)

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