Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
RoelWouters12
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
MAwwad
Super User
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 🙂

View solution in original post

3 REPLIES 3
HotChilli
Super User
Super User

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.

RoelWouters12
Frequent Visitor

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

MAwwad
Super User
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 🙂

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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