UNION Related filter

[NoneOR]

Hello, 

I have a problem in applying filter from related table, from 1 side of relationship. 'prod'[serial] = "true"

Total Rules =

    UNION(

    SELECTCOLUMNS(

        'Cons',

        "ID", 'Cons'[Id],

        "Name", 'Cons'[Name],

        "Rules", "V_1",

        "WO", 'Cons'[Work],

        "Errors", 'Cons'[V_1]),

    SELECTCOLUMNS(

        'Cons',

        "ID", 'Cons'[Id],

        "Name", 'Cons'[Name],

        "Rules", "V_2",

        "WO", 'Cons'[Work],

        "Errors", 'Cons'[V_2]))

[tamerj1 · Accepted solution]

Hi @NoneOR 

please try

Total Rules =
VAR T =
FILTER ( 'Cons', RELATED ( 'prod'[serial] ) = "true" )
RETURN
UNION (
SELECTCOLUMNS (
T,
"ID", 'Cons'[Id],
"Name", 'Cons'[Name],
"Rules", "V_1",
"WO", 'Cons'[Work],
"Errors", 'Cons'[V_1]
),
SELECTCOLUMNS (
T,
"ID", 'Cons'[Id],
"Name", 'Cons'[Name],
"Rules", "V_2",
"WO", 'Cons'[Work],
"Errors", 'Cons'[V_2]
)
)

[NoneOR]

So simple and i didnt think to put it as VAR.

TRUE()

dont need quotation marks but the mistake is on me as i wrote it with mistake at begenning.

Thank you!