Show entries with zero result of specific value

[ChrisCologne]

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

[v-juanli-msft · Accepted solution]

Hi @ChrisCologne 

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.

[AlB]

Hi @ChrisCologne 

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