Using Grand Totals of Matrix as Values in Column Chart

[newgirl]

Hi! So I have this matrix table and a column chart table in my report. The intention is for the totals of the matrix to match with the totals of the column chart, with the column chart being a visual aid for the reader while the matrix would show a breakdown of the measure.

The matrix table has 3 fields - Date (column), List of plate numbers (row), and the measure (value), because it needs to show the measure per day and per plate number.

In my column chart, I only need to show the measure per day so I only have 2 fields in there - Date(axis) and measure (value).

Using a filter pane, both visuals have the same filter applied to them (wherein only trucks with target trips should be included in calculating the measure) but the measures they show per day don't match. From the looks of it, it seems like the filter is only being applied if the list of plate numbers is included in the visual. So at this point, the matrix table shows the correct total measure per day while the column chart is showing the incorrect measure per day.

My question is: is it possible to have a separate column chart visual wherein its values would be based on the the totals of the matrix table? Please take note that I also have a calendar period slicer on the page so that the reader can filter which time period he wants to see the measures in.

[Greg_Deckler]

This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

[amitchandak]

@newgirl ,Can you share sample data and sample output in table format?

[newgirl]

Hi @amitchandak !

Here's a sample pbix of my problem

https://drive.google.com/file/d/1WCBxuiLjiT0XIztkMiQg8lox1jhiE6fo/view?usp=sharing

In the file, the 2 visuals with green titles are those with filter of "Target Trips > 0" turned on, which I expect that the numbers from these 2 visuals should match. However, the column chart is matching the numbers instead with the red matrix table which has its filter turned off, which what made me assume that the chart column visual is not being affected by the filter of "Target Trips > 0".