How to add the Selected date filter to a DAX formula.

[Anonymous]

Hi All,

I'm currently working on a project that looks at the customer satisfaction rate.

The KPI card in blue currently has the following DAX formula:

M_Sum_Positive = DIVIDE(SUMX(FILTER(sentimental_value, sentimental_value[Sentiment]=5),sentimental_value[Occurances]),(SUM(sentimental_value[Occurances])))+0

The issue I am facing is that when the data parameter is adjusted on the top right of the dashboard. The KPI figures remain the same and do not adjust accordingly.

Q) How would I amend the DAX formula so that it takes into consideration the date parameters too

My calender table is:

Thank you in advance

[Anonymous]

Hi @amitchandak 

Your solution that you provided is displaying an error; 

A function 'FILTER' has been used in a True/False expression that is used as a table filter expression. This is not allowed.

Ive tried to amend to error myself but have not had any luck

[amitchandak]

@Anonymous , is lkp_calendar joined with any column of sentimental_value

then it should filter. Else add condition

M_Sum_Positive = 
var _max = maxx(allselected(lkp_calendar ),lkp_calendar [Date])
var _min = minx(allselected(lkp_calendar ),lkp_calendar [Date])
return 
calculate( DIVIDE(SUMX(FILTER(sentimental_value, sentimental_value[Sentiment]=5),sentimental_value[Occurances]),(SUM(sentimental_value[Occurances])))
, filter( sentimental_value, sentimental_value[Date] >=_min  && sentimental_value, sentimental_value[Date] <= _max))