Login to manage your account

Your email Please enter a valid email address.

Password Forgot Password?

Please enter a valid password.

OR

Don't have an account yet? Sign up

Which DAX pattern correctly calculates percentage of total?

A DIVIDE([Total Sales], CALCULATE([Total Sales], ALL(Product)))
B [Total Sales] / SUM(Sales[Amount])
C SUM(Sales[Amount]) * 100
D CALCULATE([Total Sales]) / [Total Sales]

Answer

DIVIDE([Total Sales], CALCULATE([Total Sales], ALL(Product)))

ALL removes the filter from the denominator so it represents the grand total, while the numerator remains filtered to the current row.

All Power BI MCQs

Login to manage your account

Your email id Please enter a valid email address.

Password Forgot Password?

Please enter a valid password.

OR

Don't have an account yet? Sign up as

Jobseeker

Employer