Forum Discussion

lowbenol's avatar
lowbenol
New Member
5 years ago

Measure Problem with filter

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.

 

 

 

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

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

  • lowbenol's avatar
    lowbenol
    New Member
    5 years ago

    Thank you Anonymous  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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi lowbenol ,

     

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

     

    Best Regards,

    Jay