Hi,
It is my submission of week#5 .
Now will start on bonus part.
Enterprise DNA Power BI Accelerator – Week #5 Problem Set Final.pbix (17.1 MB)
1 Like
@Eze ,
Thanks for participating! Definitely on the right track so far, with most of this looking reallys good, but there seems to be a problem with the calculation of your YOY% measure. If you want me to take a look, please just post your PBIX file in your post and I’ll be glad to do so.
- Brian
1 Like
Getting there. I have the card filtering for movies by actor, but I’ll need to review the video that @BrianJ posted above to solve the table filtering.
I actually like that the data model isn’t ideal in this way because it provides an opportunity to learn something a little more advanced on the DAX side.
As always, thank you for these Accelerator exercises.
2 Likes
I finally completed the bonus questions
I’m not satisfied with the “Change from previous” mesure because it takes more than 20 seconds to update and this is horrible. I definitely need to improve it and any help or guidance will be appreciate.
Here is my solution :
Notes:
For the bonus questions, I defined a one-to-many relationship between the ‘Movies’ to ‘Actors’ tables and fixed the “Cross filter direction” to both even if it is not recommended. At least, this added interaction between the ‘Actors’ slicer and the “Table” and “Column” chart.
However, to keep everything on the same page and not rewrite the measures, I just disconnected the Actors slicer from the visuals concerned by the main questions, and I also disconnected the Dates slicer and the donuts chart from the visuals concerned by the bonus questions.
1 Like
Hello Brian:
Here is my submission for the “required” section of Accelerator 5.
I will address the “bonus” section over the next few days.
I know there may be errors here because two of my visuals (Budget vs Moving Average, Total Worldwide Profit) differ from the Mockup. I’ve checked my measures, they look correct. I’ll look at them again after I’ve cleared my mind.
Also, on the Breakdown by Genre Donut Chart, the data card in the center of the donut disappears when I click in the Donut visual. It reappears when I click outside of the visual. Again, I’ll look at it again; perhaps the benefit of time will reveal the error.
Regards,
John Giles
Enterprise DNA Power BI Accelerator – Week #5 John Giles.pbix (17.1 MB)
2 Likes
Hi all,
Here is my submission for the Power BI Accelerator - Week #5 
Best regards,
Joaly
2 Likes
Hi Brian, waving the white flag on the extra points. Have perused the other models, watched your video and still cannot figure out the filter process. I have a commercial model that I manipulated power query to provide a first letter column that allows users to narrow the search by selecting a letter then a second filter to select full name. It is always irksome when using the model. The model could really use your technique so looking forward to seeing the run through.
@stevens ,
Absolutely no shame in that. My dad always says, “when you find yourself in a hole, stop digging”. Being incredibly stubborn, I rarely take that advice and then frequently fall back on this strategy, intellectually knowing it won’t work:
All I end up doing is wasting time, usually on “worst practices”. Having given it a full effort, and then stopping at a sensible point, the solution will be a lot more resonant, so I think you’ll find even though you didn’t get to the goal line this time, it will have been time well spent. And bookmark that post above - I’m willing to bet by the end of Acclerator you will find yourself successfully solving similar problems.
- Brian
1 Like
@JBocher ,
Beautiful! Incredibly creative and efficient solution on the previous score exercise. The only other person I’ve ever seen use that particular approach is @AntrikshSharma, and it’s a perfect application of the technique. And flawless DAX work on the most recent 6 grosses. 
- Brian
1 Like
All,
I’ve started working on my entry for Data Challenge #16, and wanted to say that that this one is a perfect complement to the work we’ve been doing in Accelerator. The data are already very clean, they set up quite easily into a perfect star schema, and even if you’re still wrestling with some of the filter and row context aspects of DAX, you should have more than enough tools in your belt to produce a really nice entry.
And the timing works quite well too. You’ll have at least a week of peace and quiet from Accelerator while the Advisory Team and I are designing the Week #6 problem set.
No pressure - I know many of you are already putting in lots of time on Accelerator, but if you have the time and inclination to give it a go, I think you’ll find it to be a great way to apply and reinforce the concepts we’ve been working on here, as well as a hell of a lot of fun.
- Brian
4 Likes
I finally was able to write a more performing code for the “change from previous” measure. I got the solution from the work I have done in the Challenge 15.
Now its time to move to the Challenge 16
1 Like
Hi @JohnG, to stop the card disappearing when you select the pie chart: select them both together, right click and group the two objects together. You can still alter each component by double clicking on the component you want to alter.
If you alter your Budget MA measure as follows the graph will read as per Brian’s.
Currently: Budget MA =
CALCULATE( [Budget Average], DATESINPERIOD(Dates[Date], LASTDATE(Dates[Date]), * [MA Years Selected], YEAR) )
Change to: Budget MA =
CALCULATE( [Budget Average], DATESINPERIOD(Dates[Date], LASTDATE(Dates[Date]), -1 * [MA Years Selected], YEAR) )
1 Like
Hello. I’m enjoying another great Accelerator!
Some things are starting to click. I finished the primary problems solely based on the Accelerator recommended resources and other EDNA forum posts. The bonus problem is another matter. While I’m still working on the movie list, my recent releases visual has me confused.
[spoiler]
Recent Releases
I essentially was using the same technique as the movie list but was going to use the visual’s Top N filter to limit to the most recent release dates. But all the data disappears when I add the Top N filter. Not sure why that would happen. Any thoughts? This visual is currently just a table while I get the measu
[/spoiler]res correct.
Enterprise DNA Power BI Accelerator – Week #5 Brad Boehnke v1.pbix (17.2 MB)
Thanks for the help.
Brad B
Thank you, Steven. Much appreciated.
Hello Brian:
Here is my second submission for Accelerator 5.
I decided to pass on the “bonus points” section. I thought my time would be better spent addressing Challenge 16.
A few comments:
-
Thanks to stevens for his advice regarding:
a. grouping the Genre Breakdown donut and card so the card won’t disappear when the donut chart is clicked.
b. pointing out an error in my measure that calculated the Budget Moving Average. I’ve used MA’s
several times, but managed to butcher the expression in this instance. -
Regarding previous and next years lines to highlight the highest average budget: I wrote the
expression fairly quickly. I had trouble devising a means of displaying the lines themselves. I finally looked the Analytics section in the Visualization pane. The Axis Constraint functionality looked interesting, so I did some research and figured it out. However, I couldn’t come up with a way to shade the area between the lines.
I think it bears repeating, the Accelerators are a terrific means to learn practical applications of what you learn in online tutorials.
Regards,
John Giles
Enterprise DNA Power BI Accelerator – Week #5 John Giles.pbix (17.1 MB)
The Review for Accelerator 5 will be tomorrow afternoon at 5:00 PM(eastern US time)?
Will we receive a notice and link?
Thanks.
John Giles
All,
My apologies – we’re going to need to bump the Live Solution Session for Accelerator Week #5 out another week. @sam.mckay has a very busy training week this week, and an unresolvable conflict with our planned Wednesday time. I really don’t want to move forward without him, especially on this topic where I know he and I have somewhat different but equally valid approaches and I think you will benefit from seeing both of them.
I’ll work with the Enterprise DNA team tonight to get the registration link up for the session next week. In some respects this may work out well, because it provides even more of a clear path for those working on Data Challenge #16. I also have a number of questions above to respond to that I will try to get to later tonight, tomorrow at the latest.
As always, thanks for your participation and also for your insight on the recent survey. I will talk about the results at the solution session, but they’ve been very helpful in gauging the proper time and difficulty of the problem sets.
More to follow soon…
– Brian
1 Like