Profit Percentage

A Power BI report has a measure declared as:

Profit percentage = SUM(financials[Profit]) / CALCULATE(SUM(financials[Profit]), ALL(financials))

Select all the true statements if the "Profit percentage" is used as a value in a bar chart where Country is the axis.

(Select all acceptable answers.)

If there are multiple countries, the value of "Profit percentage" for each country will be 1.

If all rows in financials have a Country set, the sum of all "Profit percentage" columns in the chart will be 1.

If some countries are disabled by a page level filter, the value of each "Profit percentage" column will change.

If some countries are disabled by a visual level filter, the sum of all "Profit percentage" columns might not be 1.

Information

Difficulty: Hard

Duration: 5 min

Author: Anonymous

Score Distribution

% of candidates

0-33%

34-67%

68-100%

Score

Would you like to see our other questions?

We have 1000+ premium hand-crafted questions for 160+ job skills and 20+ coding languages. We prefer questions with small samples of actual work over academic problems or brain teasers.

Visit the Question Library

Would you like to see our tests?

The following tests contain Power BI related questions:

DAX Power BI

On the blog

Screening Applicants: The Good, the Bad and the Ugly

Since we're all biased and we use incorrect proxies, why not just outsource hiring to experts or recruitment agencies? After all, they've been screening people for many years, so they must know how to do it right?

Not really. I was surprised to discover that many experts...