Counting rows whit two filters in a Time Period

[ChrisSschmucekr]

Hallo

My goal is to show in a timeline how many persons who are active in a given time period (month) (one source of data) AND have received payments (another source of data).

I manage to calculate the active persons in the time period by using:

Active = CALCULATE(COUNTROWS('Kontaktforløb'); FILTER('Kontaktforløb'; ('Kontaktforløb'[Første hele måned] <= LASTDATE(Kalender[Datekey]) && 'Kontaktforløb'[Sidste hele måned]>= FIRSTDATE(Kalender[Datekey]))))

From here.

Result:

 

But how can I put on an extra filter from a another tabel?

My humble guess (not working):

Active with payment = CALCULATE(COUNTROWS('Kontaktforløb');FILTER('Kontaktforløb'; ('Kontaktforløb'[Første hele måned] <= LASTDATE(Kalender[Datekey]) && 'Kontaktforløb'[Sidste hele måned]>= FIRSTDATE(Kalender[Datekey]))) && LOOKUPVALUE('DREAM-Branche'[Branche];'DREAM-Branche'[FørsteIMåneden];'Kontaktforløb'[Første hele måned];'DREAM-Branche'[cpr_nr];'Kontaktforløb'[CPR FORMAT])<>BLANK())

[bsas]

Hi @ChrisSschmucekr,

You can try to create measure or create relationship beetween these tables.

In second case: 1 - create slicer like: "payment received - yes, no".

                          2 - use visual/report level filter and there indicate people who received payments.