Configuring slicers act differently on visuals on the same page

[vavs]

I have a report that has several pages with multiple charts and graphs on each page. I have a series of slicers which go from division, vp, supervisior and user.  The slicers are cascaded so when I select division, I only see the VPs for that division and so on down the line.

I am working on the summary page which has a bar chart displaying the completion rate of users at the division level.  When I only select the division level, I get the correct information.  If I select a VP for that divsion, the report displays that VPs completion rate for the division rather that what the division actually did.  The axis is based on a measure which calculates a percentage using the following dax :

COALESCE(CALCULATE(DIVIDE([QualCompY],[QualCompleteTotal])),0)

[v-heq-msft]

Hi @vavs ,

Thanks for bhanu_gautam reply.

You can also try the following dax

Measure =
COALESCE(
    CALCULATE(
        DIVIDE([QualCompY], [QualCompleteTotal]),
        ALL('Table'[VP], 'Table'[Supervisor], 'Table'[User])
    ),
    0
)

Best regards,
Albert He

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

[bhanu_gautam]

@vavs , Try using ALL 

COALESCE(CALCULATE(DIVIDE([QualCompY],[QualCompleteTotal]), ALL(VP)), 0)