Filter tab fields in basic filtering mode need to show the same count to sum total

[akhaliq7]

The filter tab fields in the basic filtering mode has a distinct list of values from the table it is from. In my scenario I have 3 orders table that I have joined together. One of the three tables has cancellations. All three tables have a calculated field called unit count whereby the 2 orders tables have a unit count of 1 and the other table has a unit count of -1. In my main page I have a card that sums up the unit count. Upto here everything is fine. The problem is in the field tab each field in the basic filtering mode shows a count for each value but the list does not match whats in either my table or my card showing the sum of unit count.

P.S. I am showing my filters on page level as that filters the card and visual level does not

[lbendlin]

Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to assist you. I cannot use screenshots of your source data.

Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523