hard20 pts · first answer countspower-bidaxmetrics

Total row is less than the sum

A Power BI table shows Distinct Customers by region: East 60, West 50. The total row shows 90, not 110. A manager thinks the report is broken. What is happening?

A.The total row is cached from an old refreshB.Power BI always rounds totals downC.The measure is re-evaluated for all regions together, and 20 customers bought in both regions, so they are counted onceD.The West region filter is applied twice

Discussion 0

Join free to post in the discussion.

Total row is less than the sum

Discussion 0

Related questions