filter and %

[aravindh10]

abc share is abc/market.state dealer is respectiveto the state.when i filter dealer in the slicer then in the main table the state dealer % changes according to it.if i have managers and i filter manager in the slicer then it should give the state dealer %.help me with this

[dax]

Hi aravindh10,

You said "the slicer then in the main table the state dealer % changes according to it.if i have managers and i filter manager in the slicer then it should give the state dealer %.help me with this". Did you mean that you have two slicer or you want to combine dealer and mangers in the same Slicer? If possible, could you please inform me more detailed information(such as your sample data and expected output)? Then I will help you more correctly.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[aravindh10]

here is the file for refrerence  https://1drv.ms/u/s!AiBXdUtF5Pt_ar_wQ8Ni1_RUG3I?e=oj5obi 

The state dealer % should be same for all the dealers in the state.it should not change when dealer is selected

help me with this.Thank you