Create a measure that Averages if a category = Contract Price or sum if a category = Costs

[CJ0323]

I want to return sum of value if category = Costs and average if Category = Contract Price. Below is what I have tried but no luck.

My Columns are Category and Value.

Total = 
SWITCH(SELECTEDVALUE('P&L Baseline'[Category],"Contract Price ($/Ton)", AVERAGEX(FILTER('P&L Baseline','P&L Baseline'[Category] = "Contract Price ($/Ton)"),'P&L Baseline'[Value]),"Costs($)",SUMX(FILTER('P&L Baseline','P&L Baseline'[Category] = "Costs($)"), 'P&L Baseline'[Value]))

[FreemanZ]

hi @CJ0323 

try like:

Total = 

SWITCH(

    SELECTEDVALUE('P&L Baseline'[Category],

    "Contract Price ($/Ton)",     AVERAGEX(FILTER(ALL('P&L Baseline'),'P&L Baseline'[Category] = "Contract Price ($/Ton)"),'P&L Baseline'[Value]),

    "Costs($)",

    SUMX(FILTER(ALL('P&L Baseline'),'P&L Baseline'[Category] = "Costs($)"), 'P&L Baseline'[Value])

)

[FreemanZ · Accepted solution]

hi @CJ0323 

try like:

Total = 

SWITCH(

    SELECTEDVALUE('P&L Baseline'[Category]),

    "Contract Price ($/Ton)", AVERAGEX(FILTER(ALL('P&L Baseline'),'P&L Baseline'[Category] = "Contract Price ($/Ton)"),'P&L Baseline'[Value]),

    "Costs($)",

    SUMX(FILTER(ALL('P&L Baseline'),'P&L Baseline'[Category] = "Costs($)"), 'P&L Baseline'[Value])

)

[CJ0323]

This appears to work well! Could I scale this to N number of categories?

[CJ0323]

No luck!
Error  is "Too many arguments were passed to the selectedvalue() function. The maximum argument count for the function is 2."