Question 650 A Sales fact contains five lines belonging to three invoices. It is correctly related many-to-one to Customer. A report asks how many invoices were issued, not how many line items exist. Which measure matches the business grain? DISTINCTCOUNT(Sales[InvoiceID]) rather than counting Sales rows COUNTROWS(Sales), which returns five lines SUM(Sales[InvoiceID]), treating invoice identifiers as amounts Count Customer rows, which counts customers rather than issued invoices Explanation Correct Answer A:InvoiceID identifies one business invoice across its lines; DISTINCTCOUNT returns three invoice entities. Incorrect Answers B:The fact line count is five, not the requested three invoices. C:Invoice identifiers are categorical keys and must not be summed. D:The customer dimension grain differs from invoice grain.
Question 651 A call center needs the value of HandlingMinutes to appear as a red label when a row falls below the accepted target and as green otherwise. Reviewers want each row to show a proportional in-cell bar for the numeric amount, not only a fixed red/green threshold color. What should be configured? Data-bar conditional formatting on the numeric column Only a plain text color label Use a background fill that highlights the entire numeric column equally Change the source to an image column Explanation Correct Answer A:Data bars encode relative magnitude for each displayed numeric cell. Incorrect Answers B:Text color alone lacks the proportional bar requested. C:A uniform background cannot encode the magnitude of each different row with proportional bars. D:Images break the intended numeric measure visualization.
Question 652 A ticket table has identifiers A, A, B, BLANK(), BLANK(). Reporting requires unique real tickets but not a count for missing IDs. Which expression matches? DISTINCTCOUNT(Tickets[TicketID]) including one BLANK DISTINCTCOUNTNOBLANK(Tickets[TicketID]) COUNTROWS(Tickets) counting all five rows SUM(Tickets[TicketID]) over textual identifiers Explanation Correct Answer B:DISTINCTCOUNTNOBLANK excludes the blank category while counting A and B once each. Incorrect Answers A:DISTINCTCOUNT includes a blank as an additional distinct value. C:COUNTROWS does not deduplicate ticket identifiers. D:Text IDs are not additive numeric values.
Question 653 A retailer groups a multi-year transaction table by MonthName to compute revenue. January 2025 and January 2026 are being combined. What group key prevents the collision? Group by both Year and MonthNumber (or a unique YearMonth key) Group by MonthName alone Sort MonthName alphabetically and keep only its first match Remove the Year column before aggregation Explanation Correct Answer A:Year plus month identifies a unique reporting period and keeps the two Januaries separate. Incorrect Answers B:MonthName repeats annually and merges distinct periods. C:Sorting changes display order, not grouping identity. D:Removing Year eliminates the distinction the requirement depends on.
Question 654 A finance team needs to investigate operating costs by Region, then Product, then Channel, selecting a different sequence of dimensions as it drills. Which visual fits this interactive hierarchical decomposition? A Decomposition tree with the cost measure in Analyze and the dimensions in Explain by A single card containing only the grand total A fixed line-chart forecast of next quarter cost A static image of the organizational hierarchy without measure values Explanation Correct Answer A:A decomposition tree lets consumers break down an aggregate across chosen explanatory categories in a flexible drill path. Incorrect Answers B:One card cannot expose component breakdowns. C:Forecasting estimates future values rather than decomposing a present total. D:A static hierarchy cannot recompute the cost breakdown as users choose paths.
Question 655 A sales-return feed has RefundAmount values -25, -40, and "not entered". An analyst treats every nonpositive row as invalid. What should cleaning do? Delete all negative refund values as data errors Replace "not entered" with zero without investigation Convert the textual missing marker to null, while retaining valid negative refund amounts under the defined sign convention Convert all refund amounts to a Boolean Yes/No field Explanation Correct Answer C:Negative return amounts can be valid signed transactions, whereas an unreported field should remain distinguishable. Incorrect Answers A:Dropping negatives would erase actual refunds. B:Unknown is not equivalent to observed zero. D:Boolean conversion loses monetary magnitude.
Question 656 A contractor’s direct report permission is revoked, but the contractor still opens the report through membership in an app audience. The goal is to remove all effective access. What should the owner investigate? Turn off visual interactions without changing permissions Remove just the semantic model description field App audience membership, group grants and direct item permissions before confirming the revocation Rename the report and keep the original audience grants Explanation Correct Answer C:Effective access can be inherited through several Power BI sharing paths; revoking one direct grant does not override another valid audience entitlement. Incorrect Answers A:Interactions govern how visuals filter each other, not who can open the report. B:Model descriptions are metadata and unrelated to report entitlements. D:A renamed report is still accessible through authorized sharing routes.
Question 657 A call center wants a persistent button-based table of contents taking report consumers to the Overview, Exceptions, and History pages. The buttons are now intended to switch between saved analytical views on one report page rather than switch physical pages. Which navigator suits this? Gateway connection editor Bookmark navigator for saved view states Page navigator for separate report pages Use a Page navigator that moves to distinct report pages, ignoring saved view states Explanation Correct Answer B:A bookmark navigator selects saved display/filter states within the current page. Incorrect Answers A:A gateway connection is not UI navigation. C:Page navigators move among pages instead of toggling states on one page. D:The requirement is to switch states on the same page; a Page navigator follows the physical page list instead.
Question 658 After combining 35 monthly invoices, a duplicated region appears only in one batch. The analyst needs to trace which input file produced the rows. Which capability should be retained? Remove all file metadata before row validation Assume the largest source file is always responsible Keep a source filename/provenance column through the Combine Files transformation until validation completes Replace invoice keys with random colors Explanation Correct Answer C:Source-file provenance lets the analyst isolate problematic rows to a specific uploaded batch. Incorrect Answers A:Prematurely dropping provenance prevents targeted source diagnosis. B:File size alone does not identify which region labels are duplicated. D:Colors are not reliable record lineage.
Question 659 A measure uses AVERAGEX(Fact, DIVIDE(Fact[Profit],Fact[Revenue])). Three rows contain (Profit,Revenue): (0,100), (50,100), and (0,0). DIVIDE has no alternate result. What is the percentage average? 16.67%, treating the blank third row as an actual 0% value in a three-row mean 50%, counting only the profitable second row 25% 0%, discarding the positive 50% entry Explanation Correct Answer C:The first valid ratio is 0%, the second is 50%, and the third is BLANK due to zero denominator. AVERAGEX includes valid zero but excludes BLANK, so (0+50)/2=25%. Incorrect Answers A:A blank outcome is not a third numeric zero in the average. B:The legitimate zero-rate first row still participates in the mean. D:The valid 50% second row must not be discarded.
Question 660 An order source occasionally revises last month’s records. Incremental refresh currently updates only the last day, leaving corrected rows stale. What policy change is warranted? Expand the refresh window to cover the permitted correction horizon and verify folding/partition behavior Only change the report theme Update one static bookmark to show the previous month Ignore legitimate corrections because a partition is older than one day Explanation Correct Answer A:The refresh window must include periods that can still change in the business source. Incorrect Answers B:Visual styling cannot update cached partition data. C:Bookmarks do not reload changed source records. D:A too-narrow window leaves known corrections unrefreshed.
