DAX formula incorrect result of Number of Appointments

[writetofaiz]

Hi,
Below is the result I am getting in Power BI report. For Number of Appointments Booked, I have used the formula:

Number of Appointments Booked = COUNT('fact'[appt_date]). For BT, I am getting value of 6, but the correct value is 1. Similarly for Exam Emergency, I am getting 11, but the correct value is 1. I can use DistinctCount instead of Count to get the correct result but I don't want to use that. Is there a way to count the records on selected columns in DAX like the one we get in SQL
Select dim_practice_key, dim_clinician_key,count(*) from table
group by dim_practice_key, dim_clinician_key

[Anonymous · Accepted solution]

Thanks for the reply from @lbendlin , please allow me to provide another insight: 

Hi  @writetofaiz ,

You can try the following measure:

Test =
var _table1=
SUMMARIZE('Table',[appt_service_description],[dim_clinician_key],[dim_practice_key])
return
COUNTX(
    _table1 ,[appt_service_description])

Best Regards,

Liu Yang

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

[lbendlin]

Looks like you want to use DISTINCTCOUNT() rather than COUNT()