PowerBi Help / Ranking

[Sirhawk3017]

Well I need some help. I have a matrix that ranks owners based on their 2023 ytd value. The 2023 value can change when a slicer is selected for month. The problem is when I select another slicer the matrix does update to only include what is on the slicer.

[Sirhawk3017]

Hi Ashish! Thanks so much for responding. When I select BDC it shows all owners. the slected bdc shows data for their owerns with the other owenrs blank. I only want selected owners to show when a bdc is selected.

[Ashish_Mathur]

Hi,

Soething to do with the relationships.  Create a seperate Dim table of Area/Region with only unique entries.  Create a Many to One and Single relationship from the BDC and Sales Summary1 table to this new table.

[Sirhawk3017]

here's a link to the file. Owner Performance.pbix

[Ashish_Mathur]

Hi,

I do not see any problem in that file.  What problem do you see and what is the expected result.  Please be very clear.