Hi am fairly new to BI & DAX and am struggling to do what I think should be very simple.
I have the following measure:
Go to Solution.
@msommerf - One potential issue:
The SELECTEDVALUE function only returns a value if there is a single value in the context. To make sure you only get a single value, you could use MAX instead.
Hope this helps,
View solution in original post
Many thanks Nathan. This worked a treat!
Join us in the third Triple A event!
It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.
Make sure you didn't miss any of the things that happened in the community in January!