Forum Discussion

Colinr's avatar
Colinr
New Member
5 years ago

Help to convert hard coded Dax filter to use current selection values

I have a Dax filter that correctly filters to hard coded values, How can I change this to use the Filters of the current PBI visualisation page filter selection, Id also like the Date to use the  SAMEPERIODLASTYEAR() for the date filter ?

 What I have so far is :

 

 

previousYear = CALCULATE (
SUM ( 'vw Monthly Milk Production'[value] ),
FILTER (
All('vw Monthly Milk Production'),
'vw Monthly Milk Production'[adjustment] == "30 Day adjustment"
&& 'vw Monthly Milk Production'[Type] == "Natural Content"
&& 'vw Monthly Milk Production'[country] == "United Kingdom"
&& 'vw Monthly Milk Production'[date] == value("2020-02-01")
)
)

 

 

1 Reply

  • Colinr's avatar
    Colinr
    New Member
    5 years ago

    Ive got a bit further with below, but the sameperiod last year function, returns an empty filed in my pbi table,  What Do I need to do to provide this expression with the correct context please ?

     

     

     

    previousYear = CALCULATE (
    SUM ( 'vw Monthly Milk Production'[value] ),
    FILTER (
    ALLSELECTED('vw Monthly Milk Production'),
    'vw Monthly Milk Production'[date] == SAMEPERIODLASTYEAR(Dates[Date].[Date])
    )
    )