Forum Discussion

carlenb's avatar
carlenb
Advocate II
2 years ago
Solved

Why doesn't ALLSELECTED work? Slicer issue

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? 

 

ALLSELECTED
DAX
Slicer
  • Greg_Deckler's avatar
    Greg_Deckler
    2 years ago

    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

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    2 years ago

    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's avatar
      carlenb
      Advocate II
      2 years ago

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

  • MichaelaMul's avatar
    MichaelaMul
    Helper III
    2 years ago

    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!