Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I am sourcing a shared dataset in my Desktop report which is Direct Query mode.
I want to refer a inactive relationship table column.
I cannot alter the datamodel.
I have tried below options but not working.
1) Related function is not allowing me.
2) VLOOKUPVALUE also not allowing.
3) USERRELATIINSHIP in Calculate also not working as I want the other column result for every row
Is there any alternative for solving the scenario.
Thanks in advance.
@Panchaks60 Are you trying to create a measure? You could try using MAXX(FILTER(...),...). Also, VLOOKUPVALUE is LOOKUPVALUE in DAX.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
71 | |
69 | |
38 | |
26 | |
26 |
User | Count |
---|---|
97 | |
96 | |
59 | |
44 | |
40 |