DAX Help - calculate filter table1[column] = table2[column]

[Anonymous]

Hello,

I can't find a solution for my dax Formula. I want to do :

CALCULATE(
  COUNT(TABLE1[COLUMN.A]),

  TABLE1[COLUMN.B] = TABLE2[COLUMN.B]

)

I have a error at the "=" filter, how to write it ?

Thanks for advice.

[amitchandak · Accepted solution]

@Anonymous , You can try a measure like

CALCULATE(
  COUNT(TABLE1[COLUMN.A]),

  TABLE1[COLUMN.B]  in values( TABLE2[COLUMN.B])

)

or try  treatas

https://www.sqlbi.com/articles/propagate-filters-using-treatas-in-dax/

[Anonymous]

Thanks you !