Forum Discussion

ahuhn's avatar
ahuhn
Icon for Advocate I rankAdvocate 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
Icon for Advocate I rankAdvocate I
7 years ago
StatusMonthUpdated
Alpha201810
Alpha201810
Beta201810
Gamma201810
Gamma201810
Alpha201809

 

When user selects parameter 201810, alpha result should be 2

when user seelcts 201809, alpha result should be 1

 

Unforunately, the parameters cannot be altered either

parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

ahuhn so if I understood correctly, you have a parameter which user uses to enter the month value and then you want to show count of status based on month value entered by users in parameter, correct?