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
MichaelaMul's avatar
MichaelaMul
Icon for Helper III rankHelper 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!