
Clean up your DAX measures with MEASURE TABLES and FOLDERS in Power BI
Quiz by Nitin Gholap
Feel free to use or edit a copy
includes Teacher and Student dashboards
Measure skillsfrom any curriculum
Measure skills
from any curriculum
Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.
With a free account, teachers can
- edit the questions
- save a copy for later
- start a class game
- automatically assign follow-up activities based on students’ scores
- assign as homework
- share a link with colleagues
- print as a bubble sheet
10 questions
Show answers
- Q1What is the first step to cleaning up DAX measures?Hide all unused measuresRename all measures to total unitsDelete all unused measuresEnsure all measures are consistently named30s
- Q2What is the purpose of creating a separate measure table?Seperate measures from the original tableCreate a connection between different tablesRename all measuresOrganize all measures in one place30s
- Q3How can you assign a measure to a measure table?Change the measure's home table propertyAdd the measure to the measure table in the modeling viewThere is no way to assign a measure to a measure tableInclude the measure name in the measure table30s
- Q4How can you hide a column in the measure table?There is no way to hide a column in the measure tableDelete the columnRename the columnMove the column to a different table30s
- Q5What are two ways to organize measures within a measure table?Create folders and subfoldersChange the data type of each measureRename all measuresUse color coding30s
- Q6How can you create a subfolder within a folder in the measure table?Use a semicolon ";" when naming the display folderThere is no way to create subfolders within folders in the measure tableUse a forward slash "/" when naming the display folderUse a backslash "" when naming the display folder30s
- Q7How can you add a measure to multiple folders in the measure table?Copy and paste the measure into each folderRename the measure with the folder namesUse a semicolon ";" to separate folder names when naming the display folderThere is no way to add a measure to multiple folders30s
- Q8How can you ensure a folder containing favorite measures always appears at the top in the report view?Name the folder with a dot "." at the beginningPin the folder to the top of the report viewAdd the word "favorites" to the folder nameThere is no way to ensure a folder always appears at the top30s
- Q9What are two benefits of using measure tables and folders?Improved organization of measuresEasier creation of calculated columnsBoth renaming measures and hiding unused measuresEasier identification of frequently used measures30s
- Q10What does the author recommend doing if you find this video helpful?Rename all your measures to "total"Delete all unused measuresLike the video and subscribe to the channelThere is nothing mentioned in the video regarding unused measures30s