Target vs Achieved

Hi srkase ,

In Power Query:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("tZWxjsIwEET/JTWFvfHaSQm+k6AARZcS8f+/cV5zkQg3JqxDCscUs09LMqO5XhsyZNOhZtfsx/M4pNsRD2O6bTpGcUTPHOTnfvhpbrsZ/Xy6nNLVjkeRkpYtAy2T4XfoFYtb9q57yXb1bM+uf4PdKtmi9+QcvWRz9d5kgy2873iI6XmIsRZNJvhltNYmomdDPmy0Nfddwd4fDM/Xd9wwPIv0isWn8JTZ68OzxF4TnjJ7fXgA+1PhWUCvCc8WW/+F5wGd/gjJd9imeSb6zN41LwX0DmTXWBD0zhP7bm+nZIse9A5ks5ItetA7T+x7dLySLXrQOxP70YRBiRY96B2E7pRo0YPeQeheiRY96J1idDRsMw38bx5ocKsOpgyA5sH0ql4D3QNNbrXpzAOgfTBdm888APoHhshqE5oHQAMhQ1ptRPMA6CAI14Y0D4AWgnBtTPPArIduvw==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [YEAR = _t, #"MINOR GROUP" = _t, PRODUCT = _t, APR = _t, MAY = _t, JUN = _t, JUL = _t, AUG = _t, SEP = _t, OCT = _t, NOV = _t, DEC = _t, JAN = _t, FEB = _t, MAR = _t, #"TOTAL QTY" = _t, TOTALVAL = _t, month = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"YEAR", Int64.Type}, {"MINOR GROUP", type text}, {"PRODUCT", type text}, {"APR", Int64.Type}, {"MAY", Int64.Type}, {"JUN", Int64.Type}, {"JUL", Int64.Type}, {"AUG", Int64.Type}, {"SEP", Int64.Type}, {"OCT", Int64.Type}, {"NOV", Int64.Type}, {"DEC", Int64.Type}, {"JAN", Int64.Type}, {"FEB", Int64.Type}, {"MAR", Int64.Type}, {"TOTAL QTY", Int64.Type}, {"TOTALVAL", Int64.Type}, {"month", type text}}),
    #"Removed Other Columns" = Table.SelectColumns(#"Changed Type",{"YEAR", "MINOR GROUP", "TOTAL QTY"}),
    #"Pivoted Column" = Table.Pivot(Table.TransformColumnTypes(#"Removed Other Columns", {{"YEAR", type text}}, "en-US"), List.Distinct(Table.TransformColumnTypes(#"Removed Other Columns", {{"YEAR", type text}}, "en-US")[YEAR]), "YEAR", "TOTAL QTY", List.Sum)
in
    #"Pivoted Column"

Then create measure:

Measure = 
var value1 = SELECTEDVALUE('Table'[20212022])
return
SWITCH(SELECTEDVALUE('Table'[MINOR GROUP]),"ASMSP",value1*1.8,"CBC",value1*2,"MINI",value1*2.5)

Best Regards,

Jay