Forum Discussion

rtaylor's avatar
rtaylor
Icon for Helper III rankHelper III
6 years ago

SeletedValue function with Date Filter not displaying properly.

Hello and Thanks in Advance!   I created a measure using selectedvalue function to display a category as a title. The problem is whenever I select any month to filter by, that isn't the first month...
Need Help
rtaylor's avatar
rtaylor
Icon for Helper III rankHelper III
6 years ago
Posting Fix. This thread solution has not been marked, because we don't have answer to why this change in formula is required
 
VarianceReport_Monthly1 =
Var DateRangemin = CALCULATE(min('Date'[Date]))
Var DateRangemax = CALCULATE(max('Date'[Date]))
Var filtername = Calculate(SELECTEDVALUE(BudgetMap[Budget Summary Ovrhead],"OHA Finances"),ALLEXCEPT('Date','Date'[Date]))

Var filternameX = CONCATENATEX(VALUES(BudgetMap[Budget Summary Ovrhead]),BudgetMap[Budget Summary Ovrhead],",")
Var reportrange = filtername & " - " & DateRangemin & " to " & DateRangemax
Return
reportrange
d_gosbell's avatar
d_gosbell
Icon for Super User rankSuper User
6 years ago
rtaylor wrote:
Posting Fix. This thread solution has not been marked, because we don't have answer to why this change in formula is required
 
Var filtername = Calculate(SELECTEDVALUE(BudgetMap[Budget Summary Ovrhead],"OHA Finances"),ALLEXCEPT('Date','Date'[Date]))

What the calculate is doing here is to ignore the filters on the date slicers. Effectively returning the value from [Budget Summary Overhead] for July. 

 

You still have an issue in your data. If you de-select "Labour" when you have "Sep" selected you will notice that the [Budget Summary Overhead] slicers will go completely empty. This is because there is no data for this column for Sep, which is why selectedvalue() is returning blank.

 

We don't need a model with real data, but if you could supply a sample model with just the 2-3 tables in question and 5-10 made up rows (that still demostrate this problem) we could diagnose the root cause of this issue. Without being able to see the relationship structure and what the data looks like it is really hard to help.