You want to create a Gauge visual that dynamically adjusts its Maximum value to 10% above the highest sales value in your dataset. Which DAX measure would correctly set the Maximum?

hard📝 Scenario Q8 of 15

Power BI - Basic Visualizations

AMaxSales = MIN(Sales[Amount]) * 1.1

BMaxSales = SUM(Sales[Amount]) / 10

CMaxSales = AVERAGE(Sales[Amount]) + 10

DMaxSales = MAX(Sales[Amount]) * 1.1

Step-by-Step Solution

Solution:

Step 1: Identify highest sales value
Use MAX function to get the highest sales amount.
Step 2: Increase by 10%
Multiply MAX by 1.1 to add 10% buffer for Maximum scale.
Final Answer:
MaxSales = MAX(Sales[Amount]) * 1.1 -> Option D
Quick Check:
Dynamic Maximum = MAX * 1.1 [OK]

Quick Trick: Use MAX and multiply by 1.1 for dynamic Maximum [OK]

Common Mistakes:

Using MIN instead of MAX
Using AVERAGE or SUM incorrectly

Master "Basic Visualizations" in Power BI

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Sheet Try Challenge Scenario Recall Dash

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions

More Power BI Quizzes

You want to create a Gauge visual that dynamically adjusts its Maximum value to 10% above the highest sales value in your dataset. Which DAX measure would correctly set the Maximum?

Step 1: Identify highest sales value

Step 2: Increase by 10%

Final Answer:

Quick Check:

Want More Practice?