cancel
Showing results for
Did you mean:
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
Solution Sage

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

Solution Sage

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

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors
Top Kudoed Authors