Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello, everyone!
I would like to count the number of values in a measure that is under 30%, the number of values in the same measure between 30% and 50% and the number of values that are above 80%. The measure with the percentage values is:
Solved! Go to Solution.
I found out what i was missing!
I had a table for the measures and a table for the projects. My measure for countx was using the table for the measures instead of the projects table. I was using this measure:
I found out what i was missing!
I had a table for the measures and a table for the projects. My measure for countx was using the table for the measures instead of the projects table. I was using this measure:
@renmello , what you wany count. Assume you want to count a column group, then you will do like
countx(summarize(table,table[group], "_1",[% Executada]),[_1]>.3 && [_1]<.5)
Thanks for the answer.
It looks like the function countx cannot work with values of type boolean.
I would like know how many values of the column i created with the measure are <30%, how many are between 30 and 50% and how many are above 80%
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
33 | |
16 | |
13 | |
10 | |
8 |
User | Count |
---|---|
59 | |
20 | |
12 | |
11 | |
10 |