DAX Patterns: Parameter table
These are in-depth video lectures of the Parameter table
This pattern is used to create parameters in a report, so that users can interact with slicers and dynamically change the behavior of the report itself. For example, a report can show the top N products by category, letting the users decide through a slicer if they want to see 3, 5, 10 or any other number of best products. The values available for a parameter must be stored in one or more disconnected tables, which do not have a relationship with any other tables of the same model. This chapter includes several examples with the parameter table, but this pattern has an even broader range of application.
Parameter table
About the Parameter table pattern
Introduction
Changing the scale of a measure
Multiple independent parameters
Multiple dependent parameters
Selecting top N products dynamically
Collection
Student Rating
Student Reviews (3)
Eamonn Kelly (Dec 8, 2023) Excellent, In depth explanation of how DAX works, when to use it and why we might want to that particular DAX or pattern given a particular business challenge we are trying to solve. Detailed focused, well built out in logical sequenced steps...Exceptional work!
Bloody good job guys!
Deborah Compton (Jul 20, 2023) Really well explained.
Claudio Trombini (Feb 8, 2021) always n.1!!!
What is included
This video course contains 21 minutes of training, for a total of 6 lectures.
Our training platform tracks your progress and resumes the course from where you left off.
The course is accessible on desktop and mobile browsers for
36 months after the purchase date .
The videos are hosted by SQLBI on vimeo.com – if you are in a country that blocks access to this platform, you will need a VPN to watch the videos.
You can download all the exclusive content produced by our trainers for this video course, including all the examples and the exercises. Take a look at the curriculum for more details.
In this video course both our senior trainers are in front of the camera. The conversational style allows for more entertaining lectures, and it answers the most common questions on the topics covered.
After completing all the lectures in this video course,
you will be able to download a certificate of completion in PDF format from your student dashboard.
Options
Volume discounts are offered when you purchase multiple courses within one same order. To obtain the discount, just press the
Enroll Now button and add more courses or students in the next step. The discount cannot be applied to transferable licenses.
Amount
Discount
$ 40010% $ 80015% $ 100020% $ 400025%
You can get a group discount by registering 10 or more students to the same course. To obtain the discount, just press the
Enroll Now button and add more students in the next step.
Students
Discount
10+ 25% 25+ 30% 50+ 40% 100+ 50% 200+ 65% 300+ 70% 350+ 72%
A team management dashboard is available if you choose to assign this course after the purchase or you get a
transferable license .
Use this tool to assign your licenses and monitor the study progress of your team.
Training Platform
Along with subtitles, you can view a transcript of the content of each lecture in different languages.
The transcripts are synchronized with the video and you can easily jump from one segment to another.
Learn more
Save the most interesting lectures for future use and easy access with bookmarks.
Press the marker button in every lecture and check the Bookmarks tab.
Learn more
You can highlight segments of the video transcripts, like you would with a printed book. Highlights are automatically saved and quickly accessible from your Bookmarks tab.
Learn more
In every section of this course, you will find an easy way to start a discussion about a topic relevant to the course.
Our team usually replies within a few hours!
Learn more
