Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
I am stuck on creating a calculated column. My table has an SR ID, Bug ID and Bug States. An SR ID could have multiptle Bugs with their respective states. My table looks like below -
SR ID | Bug ID | Bug State | Final State |
1 | a | Active | Active |
2 | b | Resolved | Active |
3 | c | Resolved | Active |
4 | d | Resolved | Resolved |
5 | e | Resolved | Resolved |
6 | f | Resolved | Resolved |
7 | a | Active | Active |
I need to create the column Final State where I have to check all the Bug states for an SR ID and if any of the bug state for an SR ID is Active then it the result is Active but if an SR has all the bug states as Resolved then it should be Resolved.
any help is appreciated.
Regards,
Rohith
Hi @RohithGn
try new measure
Measure = if(COUNTROWS(filter(ALL('Table');AND('Table'[Final State]="Active";'Table'[SR ID]=SELECTEDVALUE('Table'[SR ID]))))>0;"Active";"Resolved")
do not hesitate to kudo useful posts and mark solutions as solution
User | Count |
---|---|
125 | |
108 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |