Count row within criteria combined with different table

[lelorenzi]

I'm breaking my head on doing, and I cant get nowhere.

I have two tables only unified by relation where I can relate the offers and person and country:

And I want to do a distinct count of how many offers where above the target value, and then group the results by country:

I've tried the following measure:

CALCULATE
(DISTINCTCOUNT('Events'[Offer]),
'Events'[Offer] > SUM('Events'[Target]))

It works when I'm visualizing a table with the PersonID rows, but it doesnt work when I change to the grouped by country view.

Thanks!

[miTutorials]

I dont see any relationships between these tables.. You will have to first create relationships for the measure to work!