Forum Discussion

akhaliq7's avatar
akhaliq7
Icon for Post Prodigy rankPost Prodigy
3 years ago
Solved

Using two related columns within sumx causes error

I have a sumx function that first gets a value

if fact[date1] > related(table2'[date2]), 1, 0

 

I then use the filter function after sumx to filter by the fact table

 

Upto here the code runs fine. its when I try to filter by another 3rd table it causes an error

 

RELATED('table3[column1]) <> "Value"

 

This causes an error

 

FULL CODE BELOW:

 

CALCULATE (
    SUMX (
        'FACT TABLE',
        IF ( 
            [date1] > RELATED('table2'[date2]),
                1,
                0
        )
    ),
    'FACT TABLE'[Column2] <> "VALUE"
    RELATED('table3'[column3]) <> "VALUE"
)
DAX
Need Help
  • johnt75's avatar
    johnt75
    3 years ago

    I don't think you need RELATED for that, you can simply use 'table3'[column3] <> "value"

3 Replies

  • johnt75's avatar
    johnt75
    Icon for Super User rankSuper User
    3 years ago

    I don't think you need RELATED for that, you can simply use 'table3'[column3] <> "value"

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Hi akhaliq7 

    please try

    =
    COUNTROWS (
    FILTER (
    'FACT TABLE',
    'FACT TABLE'[date1] > RELATED ( 'table2'[date2] )
    && 'FACT TABLE'[Column2] <> "VALUE"
    && RELATED ( 'table3'[column3] ) <> "VALUE"
    )
    )

  • akhaliq7's avatar
    akhaliq7
    Icon for Post Prodigy rankPost Prodigy
    3 years ago

    ok thanks for that never knew if its in the filter function you don't need to use related. the filter function must just automatically detect the relationship. anyways thanks for that