topic Re: I've created this measure and It's not working and not showing any error in DAX Commands and Tips

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

Anonymous — Fri, 29 Apr 2022 11:07:04 GMT

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])))))

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

Anonymous — Fri, 29 Apr 2022 11:33:23 GMT

tamerj1 amitchandak Whitewater100 johnt75 Jihwan_Kim

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

tamerj1 — Fri, 29 Apr 2022 11:50:47 GMT

Anonymous

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

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

Anonymous — Fri, 29 Apr 2022 11:53:18 GMT

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

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

v-xiaotang — Wed, 04 May 2022 02:14:21 GMT

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.