Totals for report change from Unit 2 to Unit 3 and cannot determine why

Question

Completing "Modify DAX filter context in Power BI Desktop models"

In Unit 2, the total revenue is $109,809,274.

In Unit 3, the same apparent calculation is $80, 450, 596.

Following the instructions produces the same layout etc, but the calculated numbers including the %) are all wrong. Would appreciate assistance as I had been following fine until this point.

Answer 1

Hi White, Kita,

Thank you for your patience.

I understand the confusion around the differing revenue totals in Units 2 and 3. The author has clarified that these are examples, and the datasets used in both units are different. Here's some additional context:

Example Data: In training modules like these, the data used in different units doesn't always represent the same dataset. In Unit 2, the total revenue is $109,809,274, while in Unit 3, it’s $80,450,596 because the datasets are not the same. The purpose is to show how Power BI techniques, such as modifying DAX filter contexts, work in various scenarios. The actual data is secondary to learning the technique.

Focus on the Concept: While the numbers vary across units, the key focus is on how to use DAX to manipulate the filter context and not the exact matching of numbers. Following the steps correctly in each unit will help you grasp the concept, which you can then apply to your own data in the future.

Why Different Data: The use of different data is likely intentional to expose you to different scenarios that reflect real-world situations. This helps ensure that you can adapt the techniques to any dataset you might encounter when working with Power BI.

If you are still facing any issue, please let us know in the comments and where you are encountering this error along with the screenshot for reference. We are glad to help you.

If the information is helpful, please Accept Answer so that it would be helpful to community members.

Thank you.