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 ...
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"

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