Measure Problem with filter

[lowbenol]

Hello dear all,

My issue is the following:

I want to calculate the number "Matricule" which have only one Total_AT and the number of matricule which have a Total_AT greater than 1.

When I do the calculation of Atmulti with the following formula it gives me an empty result.

Total_AT = SUM (DRA [NUMBER AT])

ATmulti = CALCULATE(COUNTX('DRA','DRA'[MATRICULE]), FILTER(DRA,[Total_AT]>1))

Thank you in advance.

[Anonymous]

Hi @lowbenol ,

Your formula seems work for my sample data. Could you please share your data model to us?

Best Regards,

Jay

[lowbenol]

Thank you @saksham_jain  for your answer, i try it but still the same problem.

Total_at is a measure = sum(dra,nombre at)

i want to have the number of total by matricule.

[saksham_jain]

So I used a dummy table as below and wrote the DAX to count the Matricule that has Total_at > 1. This should help.