cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Frequent Visitor

## 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?

1 ACCEPTED SOLUTION
Super User

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 3
Super User

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

It works? Great.

Works? Great.

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

Compare to the code provided by the course.

Frequent Visitor

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

Super User

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 🙂

Announcements

#### Fabric certifications survey

Certification feedback opportunity for the community.

#### Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

#### Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors