Forum Discussion
Helper III(urgent) Group Many to One Relationship
Hello all, i reall need your help. I have to Tables:
1) Contains unique Software Applications:
ID Name
| A1111 | aaaa |
| A2222 | bbbb |
| A3333 | cccc |
| A4444 | dddd |
| A5555 | eeee |
| A6666 | ffff |
| A7777 | gggg |
| A8888 | hhhh |
| A9999 | iiii |
2) Contains Releases of Software Applications, and one Software Application can have many Releases and each Release can have different Statuses. In Table 1) i want to Identify all the Software Applications with at least one Release="Active"
ID NameRelease IDStatus
| A1111 | aaaa | 1 | Active |
| A2222 | bbbb | 1 | Inactive |
| A3333 | cccc | 1 | Phased out |
| A4444 | dddd | 1 | Pipeline |
| A5555 | eeee | 1 | Pipeline |
| A6666 | ffff | 1 | Active |
| A7777 | gggg | 1 | Inactive |
| A8888 | hhhh | 1 | Active |
| A9999 | iiii | 1 | Active |
| A1111 | aaaa | 2 | Inactive |
| A2222 | bbbb | 2 | Active |
| A3333 | cccc | 2 | Inactive |
| A4444 | dddd | 2 | Inactive |
| A5555 | eeee | 2 | Inactive |
| A6666 | ffff | 2 | Active |
| A7777 | gggg | 2 | Pipeline |
| A8888 | hhhh | 2 | Active |
| A9999 | iiii | 2 | Pipeline |
Can not solve it because i can not create a column in Table 1 referensing the Releases in Table 2) . I would like to be able to do it without sxitching the direction of the Relationship to "both". Help me please
Giavo try this.
1) Find the number of id's where release status = active for every software
2) if no of release id's with status as active is >=1 then yes else no
Active Release Flag =
VAR ActReleaseCount =
CALCULATE(COUNT(Table2[Release ID]), ALLEXCEPT(Table2, Table2[ID]), FILTER(Table2, Table2[Status] = "Active")+0
Return IF(ActReleaseCount>=1,"Yes","No")
2 Replies
Giavo try this.
1) Find the number of id's where release status = active for every software
2) if no of release id's with status as active is >=1 then yes else no
Active Release Flag =
VAR ActReleaseCount =
CALCULATE(COUNT(Table2[Release ID]), ALLEXCEPT(Table2, Table2[ID]), FILTER(Table2, Table2[Status] = "Active")+0
Return IF(ActReleaseCount>=1,"Yes","No")
GiavoUhm, it didn't work properly...Attached you can see the results. First table is the grouped IDs and second one contains the details:
for example.. A4444 must be YES because it contains "Active" status, but it is marked as NO