Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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
Hello, thank you for your feedback but the result is “empty”
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
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)
User | Count |
---|---|
12 | |
12 | |
8 | |
8 | |
6 |
User | Count |
---|---|
27 | |
19 | |
13 | |
11 | |
7 |