Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I have a measure on which I want to check that how many person have scores more than 70%. Measure values in a table format look like as shown below.
Deepak | 1 | 90% |
Dinesh | 2 | 40% |
Suresh | 3 | 78% |
Irfan | 4 | 67% |
I want count 2 as answer in another measure, but my calculation is not producing correct result. Kindly help
pc_card = SUMX(Scores,IF(CALCULATE([pc_sum], 'Scores'[pc_id])>0.7 =FALSE(),0,1))
Solved! Go to Solution.
@Minakshi , Assume name is the first column , try
countx(filter(summarize(Scores,Scores[Name], "_1",[pc_sum]),[_1] >.7),[Name])
or
SUMX(values(Scores[Name]),IF(CALCULATE([pc_sum], 'Scores'[pc_id])>0.7,1,0))
in case you need less than use <
Both of them are measures.. not calculated columns...
Both of them are measures.. not calculated columns...
@Minakshi , Assume name is the first column , try
countx(filter(summarize(Scores,Scores[Name], "_1",[pc_sum]),[_1] >.7),[Name])
or
SUMX(values(Scores[Name]),IF(CALCULATE([pc_sum], 'Scores'[pc_id])>0.7,1,0))
in case you need less than use <
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |