Forum Discussion

carlenb's avatar
carlenb
Icon for Advocate II rankAdvocate 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 cr...
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
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity 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
    Icon for Advocate II rankAdvocate II
    2 years ago

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