Create a measure that is filtered by columns from two separate tables

[Anonymous]

This is my DAX code:

Under 80% Over 60 Days = CALCULATE(COUNT('Adj Durations'[Claim]), FILTER('Adj Durations', 'Adj Durations'[All comp days] >= 60 && CALCULATE(COUNT('Claim Predictions'[Claim Number]), 'Claim Predictions', 'Claim Predictions'[Prediction Score] < 0.8)))

 I am trying to get the quantity of claims that have values from [All comp days] be greater than 60, and values from [Prediction Score] be less than 0.8, but these two columns are from different tables.

[tamerj1]

@Anonymous 

What are the relationships connecting these tables?

[Anonymous · Accepted solution]

Just had a look at the relationship between the two tables and realized it got removed, upon creating one again the problem has fixed itself 🙂

[parry2k]

@Anonymous Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490