topic Get value from a slicer when interactions are turned off in DAX Commands and Tips

Get value from a slicer when interactions are turned off

raduchirila — Thu, 25 Nov 2021 08:39:26 GMT

For a complex measure, I need to retrieve the selected value from a date slicer that has the interactions turned off with my visual.

Basically, SELTECTEDVALUE would do this, but it seems like this is working only when filtering is active. It returns BLANK once I disabled filtering from Edit Interactions.

My measure looks like this:

Variance_Actual_Forecast_Prev_Month =

VAR currentDate=MIN(dim_Calendar[Date])

VAR selectedDate=SELECTEDVALUE(dim_ReportingCalendar[Month Year]) <= this is BLANK

VAR returnVal = IF (MIN(dim_Calendar[Date]) <= [Selected Month / Current Month],

CALCULATE([Actual_USD], FILTER(MonthlyCost, MONTH(MonthlyCost[ReportingDate])=(MONTH(selectedDate)))) -

CALCULATE([Forecast_USD], FILTER(MonthlyCost, MONTH(MonthlyCost[ReportingDate])=(MONTH(currentDate)-1))))

RETURN returnVal

dim_ReportingCalendar[Month Year]) slicer:

Is there a way to get the value selected without filtering active?

Many thanks.

Re: Get value from a slicer when interactions are turned off

VahidDM — Thu, 25 Nov 2021 11:24:10 GMT

Hi raduchirila

Can you please add more details? maybe there is a way to find the desired value with active filter

Is it possible to post a sample data as text and expected output?

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
4. Relation between your tables

Appreciate your Kudos!!
LinkedIn:www.linkedin.com/in/vahid-dm/

Re: Get value from a slicer when interactions are turned off

Anonymous — Tue, 30 Nov 2021 05:36:26 GMT

Hi raduchirila,

I'm not so sure why you turn off the interactions. The basic interaction logic of power bi visuals is based on the filter effect from the relationship keys. If you turn off the interaction, it means the DAX expression does not recognize/receive any filter effect so its row content is equal to whole table field values.

Change how visuals interact in a report - Power BI | Microsoft Docs
For selectedvalue function itself, it works when only one value exists. Handle multiple values will return blank as result or you can set 'alternate result' option to handle and aggregate these records.

SELECTEDVALUE function - DAX | Microsoft Docs

>>Is there a way to get the value selected without filtering active?

You can create an unconnected parameter table that does not include a relationship to the fact table. For filter and interaction operation, you can use DAX expressions to create a measure filter to achieve them.

Applying a measure filter in Power BI - SQLBI

Regards,

Xiaoxin Sheng