DAX NOT WORKING

[amane]

I have a below measure : 

W Test 1 = CALCULATE(MAX(fact_qbrSales[Week Rank]) , FILTER(fact_qbrSales , fact_qbrSales[fiscal_start_week] < fact_qbrSales[Current_Date])) ----> This gets be the Max Week Rank

I have another measure : (This measure should calculate the Revenue for the week rank I dervied in above DAX but it is deriving the Revenue for all Weeks and not that particular Week whic

W Test 3 = CALCULATE(

[GNARR_CQ],

FILTER(fact_qbrSales , fact_qbrSales[Week Rank] = [W Test 1]

))

 

[d_gosbell]

The problem here is that you are referencing a measure in your filter expression and it will recalculate the max value of [Week Rank] based on the value of the [fiscal_start_week] for each row in your fact table. You can solve this by storing the value of the measure in a variable before doing calling the FILTER function

W Test 3 =
var _w1 = [W Test 1]
return CALCULATE(

[GNARR_CQ],

FILTER(fact_qbrSales , fact_qbrSales[Week Rank] = _w1

))

[amane]

Thanks @d_gosbell That worked! 
Another issue popping up relevant to that is now when I'm using fiscal_quarter_week as a filter I'm getting blank for the below field : 

[d_gosbell]

---

@amane wrote:

Another issue popping up relevant to that is now when I'm using fiscal_quarter_week as a filter I'm getting blank for the below field : 

---

Without being able to see the DAX for both your measures and some example data is almost impossible tell why you are getting a blank result.

If you provide some test data we can play with  (see https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523#M6071... ) it should be possible to figure out what the issue is.