How to write Filter condition on with two different tables ?

[ramshoney1225]

Hi,

I want to write a DAX, i have two tables Tablea and tableb both are joined

i need to count and count distnct measure

COUNTID = count(id) based on tablea.id = tableb.id and tablea.type = "Protect"

I need to get count based on the two conditions in DAX

table( id )= tableb ( id ) and Tablea.type = "Protect" on

Thanks

Rams

[amitchandak · Accepted solution]

@ramshoney1225 , Assume both tables has a relation ID column

Try like

calculate(count(tablea[ID]), tablea[type] = "Protect", not(isblank(tableb[ID])))

or

calculate(count(tablea[ID]),filter(tablea, tablea[type] = "Protect" && tablea[ID]= related(tableb[ID])))

[amitchandak · Accepted solution]

@ramshoney1225 , Assume both tables has a relation ID column

Try like

calculate(count(tablea[ID]), tablea[type] = "Protect", not(isblank(tableb[ID])))

or

calculate(count(tablea[ID]),filter(tablea, tablea[type] = "Protect" && tablea[ID]= related(tableb[ID])))

[ramshoney1225 · Accepted solution]

Thanks for the update,

I'm able to use the 2nd one , i didnt understand the first one.

If i dont need any hard code filter in that can i use as below right ?

calculate(

count('tablea'[ID]),

FILTER('tablea ,'tablea'[ID] = related('tableb'[ID]))       --- Where i have relation between two tables 

)

Thanks

Rams