Power BI Relationships and DAX Quiz

How would you display a value as a percentage using DAX?

• By using the DIVIDE function

• By using the FORMAT function

• By using the SUM function

• By using the COUNT function

What is the primary purpose of establishing relationships between tables in Power BI?

• To delete unnecessary data

• To connect data from different tables for analysis

• To create visualisations

• To format data as currency

Which type of relationship is commonly used in a star schema?

• Many-to-many

• One-to-one

• One-to-many

• Self-referencing

What is the function of the DAX formula `SUM`?

• To count unique values

• To add up all the values in a column

• To find the minimum value

• To calculate the average

Which DAX function would you use to calculate the number of unique accounts?

• COUNT

• DISTINCTCOUNT

• SUM

• MAX

What is the main difference between calculated columns and measures in Power BI?

• Calculated columns are used for formatting, measures are not

• Calculated columns are static, measures are dynamic

• Measures are used for text data, calculated columns are not

• Measures are used for creating relationships, calculated columns are not

Which DAX function would you use to perform a conditional sum?

• FILTER

• CALCULATE

• DIVIDE

• SWITCH

Which visualisation would you use to display a single value in Power BI?

• Table

• Card visual

• Line chart

• Pie chart

Which DAX function is similar to Excel’s VLOOKUP?

• RELATED

• RANKX

• SWITCH

• IF

What is the purpose of the RANKX function in Power BI?

• To create a new table

• To rank values in ascending or descending order

• To calculate totals

• To format data