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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Anonymous
Not applicable

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
Solution Sage
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 🙂

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.

Anonymous
Not applicable

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

MAwwad
Solution Sage
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 🙂

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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