Problem showing & countnig field from related table

[wiboc]

I have not been able to count & show unique fields from related table.

relations:

request-zispatient 

visual:

table request * patient number (from ZisPatient) 

Hoi can I countthe number of request from unique patient (not 10 but 6). 

Is het also possible to show the table with unique patient - requests?

oh, Iúsing direct query on sql-server

[v-henryk-mstf · Accepted solution]

Hi @wiboc ,

According to the data model you provided, I did the following tests and returned the expected results:

M =
CALCULATE ( DISTINCTCOUNT ( Zispatient[patientNumber] ), ALL ( Zispatient ) )

If the problem still cannot be solved, please refer to the use of the ALL function, clear the external filter conditions, and then check whether the result is displayed correctly.

Let me know immediately, looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PC2790]

You can try a DAX measure to count distinct values only, something like:

disctinctcount = DISTINCTCOUNT([patientNumber])

[wiboc]

it doesn work because every row shows and counts the requests...