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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors