Forum Discussion

ahuhn's avatar
ahuhn
Advocate I
7 years ago
Solved

use parameters in dax

I made a DAX measure:   Measure = CALCULATE(COUNT(Sheet1[Status]),FILTER(Sheet1,[MonthUpdated]="201810" && [Status]="Alpha"))   I also created a parameter YYYYMM to represent [MonthUpdated], to p...
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi ahuhn

     

    You can get the other count which is not selected by slicer with below measure. 

     

    Measure  =
    CALCULATE (
     MAX ( Sheet1[MonthUpdated] ),
     FILTER (
     Sheet1,
     Sheet1[MonthUpdated] <> SELECTEDVALUE ( Slicer[YYYYMM] )
     && Sheet1[Status] = "Alpha"
     )
    )

    Regards,

     

    Cherie

v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
7 years ago

Hi ahuhn

 

You may create a slicer table as below. Then create a measure with SELECTEDVALUE Function to get the value as requested.

Count =
CALCULATE (
    COUNT ( Sheet1[Status] ),
    FILTER (
        Sheet1,
        Sheet1[MonthUpdated] = SELECTEDVALUE ( Slicer[YYYYMM] )
            && Sheet1[Status] = "Alpha"
    )
)

Regards,

Cherie

  • ahuhn's avatar
    ahuhn
    Advocate I
    7 years ago

    Anonymous that is great, I love it!

     

    Just a follow up.

     

    I want to be able to subtract another month's value, also being chosen by the user. I tried your method, but after selecting the slicer to 201809, the second slicer is also subsetted, and thus has only one option.

     

    This is the reason I was trying to use parameters

     

    Any suggestions? Can you answer here, or shall I create a new thread?

    • v-cherch-msft's avatar
      v-cherch-msft
      Microsoft Employee
      7 years ago

      Hi ahuhn

       

      You can get the other count which is not selected by slicer with below measure. 

       

      Measure  =
      CALCULATE (
       MAX ( Sheet1[MonthUpdated] ),
       FILTER (
       Sheet1,
       Sheet1[MonthUpdated] <> SELECTEDVALUE ( Slicer[YYYYMM] )
       && Sheet1[Status] = "Alpha"
       )
      )

      Regards,

       

      Cherie