Why doesn't ALLSELECTED work? Slicer issue

[carlenb]

Hi,

I have the following ProductTable with the column Status: 

Status

Done

Ongoing

Ongoing

Done

Ongoing

Done

Done

Done

Delayed

Delayed

I'm trying to create a card visualiation for each status (Done, Ongoing, Delayed) to show % of total. I have created three measures, this one is for Done (the others is simply a copy paste using Ongoing and Delayed instead):

Var_DonePercentage =

DIVIDE(

    CALCULATE(

        COUNTROWS(ProductTable),

        ProductTable[Status] = "Done"

    ),

    CALCULATE(

        COUNTROWS(ProductTable),

        ALLSELECTED(ProductTable[Status])

    ))

This works as long as I don't filter anything, see below.

However when I select for example "Done" in the slicer, the others should be 0% to avoid confusion. How can I make this happen? 

[MichaelaMul]

Hi everyone! I am having a similar issue. I made the following measures to get the volume share of each category in a specific brand in my dataset. The two top measures are working properly, with the category measure filtering properly when selected. However, when I combine the two measures to divide it the ALLSELECTED measure stops working. What am I doing wrong?

Total for Category = 
CALCULATE (SUM('DATA'[Volume]), 'DATA'[Brand] = "ABC", ALLSELECTED('CategoryTable'[Category]))

Total for Brand = 
CALCULATE (SUM('DATA'[CY Reforecast]), 'DATA'[Brand] = "ABC")

Total for Category divided by Total for Brand =
DIVIDE([Total for Category], [Total for Brand])

Thanks!

[Greg_Deckler · Accepted solution]

@carlenb Was getting weird results with CALCULATE but this No CALCULATE approach works just fine. 

Var_DonePercentage 1 = 
DIVIDE(
    COUNTROWS(
        FILTER('ProductTable', [Status] = "Done")
    ),
    COUNTROWS(ProductTable)
) + 0

[carlenb]

@Greg_Deckler genius! Thanks Greg, got it to work. This week suddently looks brighter 🙂