Forum Discussion
BIswajit_Das
Impactful Individual
Impactful IndividualPower bi Tables
Current table
| AC | RESQ | PART | RES | FAVOR |
| 1 | A | 1001 | 1 | A |
| 1 | B | 1001 | 1 | B |
| 1 | C | 1001 | 1 | C |
| 1 | D | 1001 | 1 | D |
| 1 | B | 1002 | 2 | B |
| 1 | B | 1002 | 2 | B |
| 1 | O | 1002 | 3 | O |
| 1 | O | 1002 | 3 | O |
| 1 | O | 1002 | 3 | O |
required table
| AC | RESQ | PART | RES | FAVOR |
| 1 | A | 1001 | 1 | DRAW |
| 1 | B | 1001 | 1 | DRAW |
| 1 | C | 1001 | 1 | DRAW |
| 1 | D | 1001 | 1 | DRAW |
| 1 | B | 1002 | 2 | O |
| 1 | B | 1002 | 2 | O |
| 1 | O | 1002 | 3 | O |
| 1 | O | 1002 | 3 | O |
| 1 | O | 1002 | 3 | O |
Thanks
1 Reply
- BIswajit_Das
I used the above dax and it's working fine for most cases but incase of single RES per PART it's returning "DRAW" also which is not right it should returned the sigle value as max count. I guess need to modified the query to handle that issue. Any suggestions
Thanks
