DAX

[Anonymous]

Hi,

I have been following an online power BI course and all the measure I have used untill now have worked. however the current one won't work and I can not get my head around it.

The problem:

I need to create a Calculations using DAX  measure based on rows in a column, in the explanation video from davidson university it works straight away but when I put it in it states table not found. 

formula:

GDP = CALCULATE(SUM(indicators[Value]), ( indicators[Indicator Code]) = 'NY.GDP.MKTP.CD')

Any one that has some advice?

[HotChilli]

You'll probably learn more if you solve this yourself.

Simplify the DAX and test it.  Start with SUM(indicators[Value])  .. Just use that as a measure.

It works? Great.

Add a calculate.

Works? Great.

Add the condition.

Maybe it breaks.  Dig in at that point.  Check syntax, brackets, quotes.

Compare to the code provided by the course.

[Anonymous]

Thanks a lot, dumb mistake! I will blame it on wathcing too much to the screen

[MAwwad · Accepted solution]

Hello,

Try this GDP = CALCULATE(SUM(indicators[Value]), ( indicators[Indicator Code]) = "NY.GDP.MKTP.CD")

You must use " and not '

Dont forget to accept this as a solution if it helped 🙂