Selecting the filter changes the state dealer %

[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 yo

[v-yuta-msft]

@aravindh10 ,

Select the Dealer slicer-> click Format-> Edit interactions, then click the disable interaction button in the DealerStateName slicer like below:

 

Community Support Team _ Jimmy Tao

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

[aravindh10]

Actually the slicer is in hierarchy with the manager so i cant disable the slicer

[sturlaws]

hi,

you could try something like this

state dealer % =
CALCULATE (
    [abc share];
    FILTER (
        ALLEXCEPT ( 'test (2)'; 'test (2)'[types] );
        'test (2)'[DealerStateName] = SELECTEDVALUE ( 'test (2)'[DealerStateName] )
    )
)

regards,

Sturla

[aravindh10]

what to do when types and state name are from different table?

[sturlaws]

That will depend on the relationship between the tables. If you update your sample report accordingly, it will be easier to suggest a solution