I've created this measure and It's not working and not showing any error

[Anonymous]

I've created this measure and when I'm selecting values from both the ref table I am getting blank chart
Test =

CALCULATE(

IF(SELECTEDVALUE('Price grouping'[Price grouping])="weekly" && SELECTEDVALUE('Select Price PPC'[Select Price])="Average promo price",[Average Promo Price],

IF(SELECTEDVALUE('Price grouping'[Price grouping])="weekly" && SELECTEDVALUE('Select Price PPC'[Select Price])="Minimum price",[Minimum Total price Week],

IF(SELECTEDVALUE('Price grouping'[Price grouping])="weekly" && SELECTEDVALUE('Select Price PPC'[Select Price])="Average shelf price",[Average Non Promo Price],

IF(SELECTEDVALUE('Price grouping'[Price grouping])="weekly" && SELECTEDVALUE('Select Price PPC'[Select Price])="Average price",[Total price])))))

[v-xiaotang]

Hi @Anonymous 

Thanks for reaching out to us.

What are you trying to calculate? Could you share some sample data and your expected result? Thanks.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

@tamerj1 @amitchandak @Whitewater100 @johnt75 @Jihwan_Kim 

[tamerj1]

@Anonymous 

Tgis measure will return blank. What do hou want to achieve?

[Anonymous]

I want to show the measure value based on the ref table selection.