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

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