Count the number of rows with a condition on a measurement table

[Greg0ry]

Hello, I would like to count the number of "clients indépedants" who have at least 1€ of "CA N". The “CA N” is a measuring table. Can you help me? THANKS

[Greg0ry]

Hello, thank you for your feedback but the result is “empty”

[Anonymous]

Hi @Greg0ry ,

What is data type of "CA N"? Please check it's data type is number. If the result is still blank, I recommend that you provide a pbix file (which does not contain sensitive data) or a demo file with the same problem. This will help us to investigate the issue better.

Best regards,

Mengmeng Li

[Anonymous]

Hi @Greg0ry ,

Here is another method for your reference. You can show the result on a Card.

Measure = COUNTROWS(FILTER(Table,[CA N]>=1))

Thanks for @Gabry reply, that's really helpful!

Best regards,

Mengmeng Li

[Gabry]

Hello @Greg0ry ,

based on the info you provided the measure could look like this:

Measure N.client=Calculate(distinctcount('Your table'[clients independent]), sum('your table'[CA N])>1)