Matrix sees a share of category as 100% even if it is not (when slicer applied)

[preacher_baby]

Hey everyone,

the problem at hand is in the following screenshots. We have a matrix visual with categories and calculation groups:

you can see that each category has its own share and the total is 100%. but when I select a category from slicer above:

it forgets it is a share. the measure is as follows:

DIVIDE(
    SUM(Category[volume]),
    CALCULATE(
        SUM(Category[volume]),
        ALLSELECTED(Category_Manuf_Brand[category])
    )
)

[amitchandak · Accepted solution]

@preacher_baby , if you need % even after slicer selection you should all in place of allselected  

Try like

DIVIDE(
    SUM(Category[volume]),
    CALCULATE(
        SUM(Category[volume]),
        ALL(Category_Manuf_Brand[category])
    )
)