Using Calculated column in DAX Measure

[Anonymous]

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)