In this example, each row in the matrix visual farthest to the right is showing the Amount for each salesperson/date combination. Take a look at the following matrix visuals. This means you can end up with different values in the total row than you might expect. For total and subtotal rows, Power BI evaluates the measure over all rows in the underlying data – it isn't just a simple addition of the values in the visible or displayed rows. Understanding how Power BI calculates totalsīefore jumping into how to use the matrix visual, it's important to learn how Power BI calculates total and subtotal values in tables and matrices. Sharing your report with a Power BI colleague requires that you both have individual Power BI Pro licenses or that the report is saved in Premium capacity.
0 Comments
Leave a Reply. |