Records are not matching between Charts and Table

[damit23183]

Hi,

I have dashboard where i want functionality like if i choose record from column chart then data should filter in table as well.  

For example: If i have number of IDs in chart are 3 then there must be 3 records should shown up in table but i am getting much more than that number every time.

Here is formula i am using to do count of IDs based on some filter.

 Population = AVERAGEX('MasterCalendar', CALCULATE(COUNT('Assignment'[id]),
FILTER('Assignment','Assignment'[StartDate] <= FIRSTDATE('MasterCalendar'[Date]) &&
(ISBLANK('Assignment'[TerminationDate]) || 'Assignment '[TerminationDate] >= FIRSTDATE('MasterCalendar'[Date])))))

Here there is no relationship between Master Calendar and Assignment table becuase i am using Master Calendar just for filteting pupose and as slicer becuase client want to see weekly based data.

Here is dashboard looks like and my apologies for red marks everywhere becuase it is information that i can not share with anyone.

If you look at the number there must be 3 but in table there are 13.

NOTE: There are 4-5 different visulization and every where number are matching except TABLE where i am getting more numbers then selected.

Any help appreciated!

Thanks

[aj1973]

@damit23183 

Have you tried to use Synchronized slicers?

[damit23183]

Yes Sync Slicer is ON.

Thanks

[jdbuchanan71]

@damit23183 

In total your table does match the 3.  It is the additional category splits in the highlighted columns that is causing more that 3 rows to show up but on the total row which ignores those categories you get 3.

[nvprasad]

Hi,

Visuals are showing summarized information whereas table might have some detailed informative rows (more unique values row).

If this makes sense for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.

Regards,

Venkata Nalla

[damit23183]

Hi,

Thanks for responding but not i would like to match the records like when i select 3 then i should see 3 records in Table too.

Thanks

[v-easonf-msft]

Hi , @damit23183 

If you  remove the second  field  which you have mark red  and the last field "AssignmentStatus"  in the table visual, will you get the 3 records you want?

Best Regards,
Community Support Team _ Eason

[jdbuchanan71]

Then you will have to remove the columns that are causing the additional splits or set those fields to only show the first value.

[aj1973]

@damit23183 

Is this close to what you are looking for?

https://www.fourmoo.com/2017/11/21/power-bi-using-a-slicer-to-show-different-measures/