Forum Discussion
madhav2020
5 years agoFrequent Visitor
Dax query to count unique values in a column by comparing it with other column
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 |