Need Help creating yes no fields

[Raf_Joker]

Hi Guys,

I have some data from Jira and I am trying to group some labels and show it against the issues table with a yes no column, however its producing yes and no results, meaning I have 2 rows per issues on each group I made.

I need it to be only 1 row in which if it contains that label I want it to say yes and if doesn't I want it to say no on 1 row as shown on my ideal screenshot.

How can I accomplish this?my attemptideal outcomerelationship between tables

[danextian · Accepted solution]

Hi @Raf_Joker ,

I am confused. What is exactly is your ideal outcome? The relationship view doesn't show how you want the data to be shown in  a visual.  If you want it to just show Yes per unique ISSUE_KEY, you can create a calculated column that counts the number of yes per ISSUE_KEY  and if that yes is more than 0 then return Yes for all the rows of that ISSUE_KEY. Sample formula

yes/no =
VAR YesCount =
    CALCULATE (
        COUNTROWS ( Labels ),
        Labels[Yes/No Column] = "Yes",
        ALLEXCEPT ( Labels, Labels[ISSUE_KEY] )
    )
RETURN
    IF ( _YesCount > 0 || _YesCount <> BLANK (), "Yes", "No" )

[Raf_Joker]

Thank you, yes that has helped and will give me my desired outcome.