Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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:
Solved! Go to Solution.
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 🙂
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.
Thanks a lot, dumb mistake! I will blame it on wathcing too much to the screen
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 🙂
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
84 | |
72 | |
68 | |
41 | |
35 |
User | Count |
---|---|
108 | |
56 | |
52 | |
48 | |
41 |