Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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%
User | Count |
---|---|
59 | |
22 | |
18 | |
18 | |
16 |
User | Count |
---|---|
85 | |
54 | |
45 | |
39 | |
21 |