Forum Discussion

Kpham's avatar
Kpham
Icon for Resolver I rankResolver I
5 years ago
Solved

Filter on a measure

 

PreviousWeekVulnerabilites = CALCULATE(SUM('FACT'[Count]),DIM_DATE[Index]=177-1)

Measure 2dim = MAX(DIM_DATE[Current Index])-1

PreviousWeekVulnerabilites = CALCULATE(SUM('FACT'[Count]),DIM_DATE[Index]=[Measure 2dim])

 

Can somebody help with the above dax code? The first line does exactly what I need. How ever the value 177 is the index of the current week and I want to make this dynamic. Measure 2dim should give the same result as 177-1, however i'm getting the message:
How should I make the statement so that I get rid of the error. I'm trying to get the count of last week vulnerabilities. 

 

Need Help
Show and Tell
  • Fowmy's avatar
    Fowmy
    5 years ago

    Kpham 

    Can you try the following modified measure:

    PreviousWeekVulnerabilites = 
var __date = MAX(DIM_DATE[Current Index])-1 return
CALCULATE(
    SUM('FACT'[Count]),
    DIM_DATE[Index]=__date
)

2 Replies

  • Fowmy's avatar
    Fowmy
    Icon for Super User rankSuper User
    5 years ago

    Kpham 

    Can you try the following modified measure:

    PreviousWeekVulnerabilites = 
var __date = MAX(DIM_DATE[Current Index])-1 return
CALCULATE(
    SUM('FACT'[Count]),
    DIM_DATE[Index]=__date
)
  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    5 years ago

    Hi,

    Does this measure work?

    PreviousWeekVulnerabilites = CALCULATE(SUM('FACT'[Count]),filter(values(DIM_DATE[Index])=[Measure 2dim]))