Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

DAX

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?

 

 

 

Need Help
  • MAwwad's avatar
    MAwwad
    3 years ago

    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 🙂

3 Replies

  • HotChilli's avatar
    HotChilli
    Community Champion
    3 years ago

    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's avatar
    Anonymous
    Not applicable
    3 years ago

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

  • MAwwad's avatar
    MAwwad
    Solution Sage
    3 years ago

    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 🙂