ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 70-778 All Questions

View all questions & answers for the 70-778 exam
Go to Exam

Exam 70-778 topic 1 question 38 discussion

Actual exam question from Microsoft's 70-778
Question #: 38
Topic #: 1
[All 70-778 Questions]

Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.
Start of repeated scenario.
You have a Microsoft SQL Server database that has the tables shown in the Database Diagram exhibit. (Click the Exhibit button.)

You plan to develop a Power BI model as shown in the Power BI Model exhibit. (Click the Exhibit button.)

You plan to use Power BI to import data from 2013 to 2015.
Product Subcategory[Subcategory] contains NULL values.
End of Repeated Scenario.
You implement the Power BI model.
You need to add a measure to rank total sales by product. The results must appear as shown in the following table.

Which DAX formula should you use?

  • A. Product Ranking = RANKX(ALL('Product'), [SalesAmount],,Asc, Dense)
  • B. Product Ranking = RANKX(ALL('Product'), [SalesAmount],,DESC, Skip)
  • C. Product Ranking = RANKX(ALL('Product'), [SalesAmount],,DESC, Dense)
  • D. Product Ranking = RANKX(Product, [SalesAmount],,DESC, Skip)
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
References:
https://msdn.microsoft.com/en-us/library/gg492185.aspx
by Fabsss at Aug. 21, 2019, 1:48 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
rhsdeal
Highly Voted 5 years, 9 months ago
The answer is C and from the documentation: Dense - The next rank value, after a tie, is the next rank value. For example if five (5) values are tied with a rank of 11 then the next value will receive a rank of 12. https://docs.microsoft.com/en-us/dax/rankx-function-dax
upvoted 11 times
...
cs3122
Highly Voted 5 years, 5 months ago
The only correct answer here is C.
upvoted 6 times
...
Vi1125
Most Recent 4 years, 8 months ago
If you look at the RANK column, row 3, if SKIP was being used after the two ties for row 1 and row 2 it would skip to the rank of 3 (which it does not, 1+1+1), if DENSE was being used after row 1 and row 2 with a tie being '1', it would assign the rank of '2' as it does.
upvoted 1 times
...
lukeonline
4 years, 9 months ago
it is C for sure. DENSE and SKIP is NOT handling the ties, but the next ranked value AFTER the tie. So both scenarios include ties. SKIP: 1-2-3-3-3-6-7-8-8-10-11-12-13-14-14-14-14-18 DENSE: 1-2-3-3-3-4-5-6-6-7-8-9-10-11-11-11-11-12
upvoted 2 times
...
cromastro
4 years, 9 months ago
It's easy enough to test. Add a table (Enter Data) with the two columns Product, Sales. Add the data as seen. Add the Measure. Add all three to a table on the visualization canvas. Answer is C.
upvoted 1 times
...
r8d1
4 years, 11 months ago
A. NO. Want to list DalesAmount in DESC B. No. 'Skip' would give ranking as 1,1,3,... C. Yes D. No. 'Skip' would give ranking as 1,1,3,... I hope this helps.
upvoted 4 times
...
Eric777
5 years ago
I'm not convinced that any of these will work. The questions explicitly says, "The results must appear as shown in the following table." That table shows values that are ties. Both the Skip and Dense arguments determine how to break a tie. As I understand this question, ties are a requirement, no? Did I miss something?
upvoted 1 times
...
lozqt
5 years, 3 months ago
MEASURE = RANKX(ALL(Table_dimension);SUMX(RELATEDTABLE(Table_faits);SALES[TotalCost]);;DESC;Dense) I tried this and it work, I obtained a ranking from one to ten. Each of my values has a ranking being the following number from one to ten. If that can help !
upvoted 1 times
...
Brunobsv
5 years, 8 months ago
Skip and Dense are related to the ties in Data Raking. Skip literally skips the rank when a tie takes places. So having Skip in this case scenarios are highly unlikable.
upvoted 4 times
...
Fabsss
5 years, 9 months ago
According to the documentation, it should be skip and not dense.
upvoted 1 times
youma
5 years, 8 months ago
nope. Absolutely you are wrong. I simulated it. DENSE is the right answer >> C
upvoted 28 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel