Using Calculated column in DAX Measure

Anonymous — Mon, 06 Mar 2023 08:51:43 GMT

Hello,

Im currently calculating a ranking where i need to get the top 20% base on the highest final score but they should be tagged as "Met". My "Met column" is a calculated column and im getting an error when im using Met Column in my dax calculation. I want to calculate who are the top 20% agent that was tagged as "Met"

Pct80 QA Score=

var temptable = SUMMARIZE(ALLSELECTED('Main Table'),'Main Table'[EID.email],"Rank", [Rank])

var tempdecile= 0.8

return PERCENTILEX.INC(temptable,[Rank],tempdecile)

Revised code. (Trying to get to top 20% that was tag "Met")

Pct80 QA Score1 =

var temptable = SUMMARIZE(ALLSELECTED('Main Table'),'Main Table'[EID.email],"Rank", [Rank])

var Met = SUMX('Main Table','Main Table'[met not met 1/0])

var tempdecile= Met*0.2

return PERCENTILEX.INC(temptable,[Rank],tempdecile)

topic Using Calculated column in DAX Measure in DAX Commands and Tips

Using Calculated column in DAX Measure