Forum Discussion

matrix_user's avatar
matrix_user
Icon for Helper III rankHelper III
4 years ago
Solved

Slicer DAX

1) I am trying to get all my options in the slicer to show values. Currently, I can only see values in the cluster column visual for “Y”: 2) If I click to “W” or “Q” or “M” no values show up i...
DAX.
slicers
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi matrix_user 
    This is one of the simplest and greatest ideas I've ever seen and I really thank you for for posting this. 
    A small fix and all good to go https://www.dropbox.com/t/vxCj7mCtgVRteRcN

    QTY Total : = 
SWITCH (
    SELECTEDVALUE ( Slicer[Index Desc], 1 ),
    1,
        CALCULATE (
            SUM ( ScooterSales[Sold Cash] ),
            TREATAS ( VALUES ( Slicer[Period] ), 'Calendar'[Year] )
        ),
    153,
        CALCULATE (
            SUM ( ScooterSales[Sold Cash] ),
            TREATAS ( VALUES ( Slicer[Period] ), 'Calendar'[YearQuarter] )
        ),
    165,
        CALCULATE (
            SUM ( ScooterSales[Sold Cash] ),
            TREATAS ( VALUES ( Slicer[Period] ), 'Calendar'[Month] )
        ),
    5,
        CALCULATE (
            SUM ( ScooterSales[Sold Cash] ),
            TREATAS ( VALUES ( Slicer[Period] ), 'Calendar'[Year&WeekNumber(a)] )
        ),
    CALCULATE (
        SUM ( ScooterSales[Sold Cash] ),
        TREATAS ( VALUES ( Slicer[Period] ), 'Calendar'[Year] )
    )
)

     

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Hi matrix_user 
This is one of the simplest and greatest ideas I've ever seen and I really thank you for for posting this. 
A small fix and all good to go https://www.dropbox.com/t/vxCj7mCtgVRteRcN

QTY Total : = 
SWITCH (
    SELECTEDVALUE ( Slicer[Index Desc], 1 ),
    1,
        CALCULATE (
            SUM ( ScooterSales[Sold Cash] ),
            TREATAS ( VALUES ( Slicer[Period] ), 'Calendar'[Year] )
        ),
    153,
        CALCULATE (
            SUM ( ScooterSales[Sold Cash] ),
            TREATAS ( VALUES ( Slicer[Period] ), 'Calendar'[YearQuarter] )
        ),
    165,
        CALCULATE (
            SUM ( ScooterSales[Sold Cash] ),
            TREATAS ( VALUES ( Slicer[Period] ), 'Calendar'[Month] )
        ),
    5,
        CALCULATE (
            SUM ( ScooterSales[Sold Cash] ),
            TREATAS ( VALUES ( Slicer[Period] ), 'Calendar'[Year&WeekNumber(a)] )
        ),
    CALCULATE (
        SUM ( ScooterSales[Sold Cash] ),
        TREATAS ( VALUES ( Slicer[Period] ), 'Calendar'[Year] )
    )
)

 

matrix_user's avatar
matrix_user
Icon for Helper III rankHelper III
4 years ago

tamerj1... a big thank you to you!