countrows based on slicer & related table

[E_hit]

Hi,

I've got 2 tables

- one with my list of clients

- another with list of apointments related to clients with a date

I want to set a date slicer in excel to get the number of apointments per clients at a given date / date range

I have created a measure :

Date_selected:=max(tbmkg_apointment[Date_apointment])

and a calculated column in my client table but I either go the total number of apointment non related to distinct client with this formula

CALCULATE(
COUNTROWS(tbmkg_apointment);
FILTER (tbmkg_apointment;
tbmkg_apointment[Date_apointment]>= tbmkg_apointment[Date_selected] ) )

or a results taht take into account all apointments for one client even if only one of them is at the desired date:

CALCULATE(
COUNTROWS(RELATEDTABLE(tbmkg_apointment));
FILTER (RELATEDTABLE(tbmkg_apointment);
tbmkg_apointment[Date_apointment]>= tbmkg_apointment[Date_selected] ) )

Any insights?

Below is a data sample:

table client

code_client	nb_apointment	client_age
4641231254	1	23
4641231255	1	36

table apointment

code_apointment	date_apointment	type_apointment	code_client
323	23/05/2018	A	4641231254
565	24/05/2018	B	4641231255

I want my calculate field in my client table in nb_apointment

Thanks!

[Greg_Deckler]

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

[E_hit]

Hey,

I just added my data sample, hope it's clearer!