You have the dataset shown in the following exhibit. You need to ensure that the visual shows only the 10 cities that have the highest sales profit. What should you do?
A.
Add a Top N filter to the visual.
B.
Configure the Sales Profit measure to use the RANKX function.
C.
Add a calculated column to the table that uses the TOPN function. In the visual, replace Sales Profit with the calculated column.
D.
Add a calculated column to the table that returns the city name if the city is in the top 10, otherwise the calculated column will return "Not in Top 10". In the visual, replace Sales Profit with the calculated column.
Suggested Answer:A🗳️
Power BI Top N Filters are useful to display the top performing records, and Bottom N filters are helpful to display the least performing records. For example, we can display top or bottom 10 products by orders or sales. Note: 1. Select the Column you want to display the Top Sales Profit 2. Then change the Filter Type of that Column to Top N 3. Fill in Top / Bottom number field 4. And lastly drag to the By Value filed your Sales Profit Incorrect Answers: B: You would need a filter as well. Reference: https://www.tutorialgateway.org/power-bi-top-10-filters/
I just tested and in order to filter the visual by a Top N filter on City field, you must add a field on a box the filter has. I added the sales field and then clicked on Apply filter (this button is grayout until you add the value field) and Woalah, It filtered by Top 10 Cities with highest amt of sales. So I think A is the most reasonable answer for this question.
Hi..I am planning to take exam this week.Could you please let me know if it is possible to pass the exam by referring to the dumps in this site only. I have 2 years experience in Power BI.
I have my exam on Tuesday and started with the MS learning paths on Saturday (learning paths are quite easy if you have experience, exam questions can be tricky) (I am taking 1 day learning paths and 1 day reviewing questions, plus after working hours/in between on monday some revision)
A measure configured in such a way as to return BLANK() for ranks higher than 10 would achieve the same result, but A is an easier approach, and maybe you will need the original measure for other visuals as well.
upvoted 2 times
...
This section is not available anymore. Please use the main Exam Page.DA-100 Exam Questions
Log in to ExamTopics
Sign in:
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.
Hermenez
Highly Voted 4 years, 6 months agoMohsenY
3 years, 1 month agosandra1981
Highly Voted 4 years agohalfway
Most Recent 2 years, 7 months agoAngell
2 years, 11 months agoAshley090521
3 years, 2 months agoZee10
3 years, 5 months agofrancis6170
3 years, 8 months agoPavanGM80
3 years, 8 months agoIhueghian
3 years, 6 months agoali0912
3 years, 9 months agotramynt
3 years, 9 months agoPenniWize
3 years, 11 months agoPraveenkumar0017
3 years, 11 months agofhqhfhqh
3 years, 11 months agoAnnaAbru
3 years, 10 months agohendriktytgatpwc
3 years, 10 months agoJESUSBB
4 years, 2 months agofergusgarden
4 years, 5 months agoF_Bastiat
4 years, 6 months ago