Multi-level slicer doesn't hold the top level

[AABright]

I am filtering States to Care Partners with the states. But there is a Care Partner, Bright Managed, that appears within each state. When I select the slicer to Bright Managed, it filters all the values for Bright Managed from all the states

The results should show different output for each 'Bright Managed' within each state - not the aggregate of them all.

[Anonymous · Accepted solution]

Hi @AABright ,

In order to provide you a suitable solution, could you please share some sample data which apply on your visuals (exclude sensitive data) with Text format and Fields pane setting of your visuals. If it apply any measure or calculated column, please provide the related formula of measure or calculated column. By the way, the field [State] and [Care Partner] from the same table? It is better if you can share a simplified pbix file. Thank you.

How to upload PBI in Community

Best Regards

[amitchandak]

@AABright , either this measure use all(state) or the table of this measure is not joined with state