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.
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))
Go to Solution.
@Minakshi , Assume name is the first column , try
countx(filter(summarize(Scores,Scores[Name], "_1",[pc_sum]),[_1] >.7),[Name])
in case you need less than use <
Proud to be a Super User!
View solution in original post
Both of them are measures.. not calculated columns...
Is your % calculation a calculated column or a measure?/ J
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.