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"

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