How to Calculate the expression based on text filter ?

[Anonymous]

Hello, 

I want to calculate the average of the Values if the Parameter field is "Gross Profit" else calculate the sum of the Values, which is like shown below;

Net = IF(POC[Parameter] = "Gross Profit",  AVERAGE(POC[Value]), Sum(POC[Value])) 

But Power Bi doesn't allow me to create a measure with my expression. What wrong I am doing here?

any help is appreciated

thanks

[v-lili6-msft · Accepted solution]

hi, @Anonymous

You could use SELECTEDVALUE Function in you formula as below:

Net = IF(SELECTEDVALUE(POC[Parameter]) = "Gross Profit",  AVERAGE(POC[Value]), Sum(POC[Value]))

Result:

Basic data

Best Regards,

Lin

[Anonymous]

thank you @v-lili6-msft it worked out