The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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:
Is there a way to get the value selected without filtering active?
Many thanks.
Solved! Go to Solution.
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
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
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/
User | Count |
---|---|
28 | |
12 | |
8 | |
7 | |
5 |
User | Count |
---|---|
34 | |
15 | |
12 | |
7 | |
6 |