Hi all,
I have a little count / group by issue. My data is as follows: 1 Row has references(=link) to other rows. Each reference has a "type". It can be "related" or "child" or "tested by" (this data is coming from Azure DevOps). Now what I want to do is: Show all rows which are missing a specific reference/link type. Here is the data:
Left two columns show the source item, right two columns the referenced/linked item. I need to know: Which source items do NOT have at least one reference of type "Test Case". In the above example all except 12805 should be in the result.
I already did a group by but that doesn't have the condition I need.
Any ideas?
Thanks!!
Best,
Chris
1 ACCEPTED SOLUTION
You could create a measure, then apply the measure to visual level filter so the table visual only show rows where [measure] =1
Measure = var c=CALCULATE(COUNT(Table2[WorkItemId]),FILTER(ALLEXCEPT(Table2,Table2[WorkItemId]),Table2[Links.WorkItemType]="Test Case")) return IF(c=BLANK(),1)
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
You could create a measure, then apply the measure to visual level filter so the table visual only show rows where [measure] =1
Measure = var c=CALCULATE(COUNT(Table2[WorkItemId]),FILTER(ALLEXCEPT(Table2,Table2[WorkItemId]),Table2[Links.WorkItemType]="Test Case")) return IF(c=BLANK(),1)
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
CAn you paste a smaple of your data here in text-tabular format (instead of in a screen cap)?
Please mark the question solved when done and consider giving kudos if posts are helpful.
Contact me privately for support with any larger-scale BI needs
Cheers
