Forum Discussion
Cross Filtering not working as expected.
Hi Guys, I have a report that shows the number of appointments that are at stage work in progress (WIP) and also how many of these are >2 days. I have the following measures on my report: Tot...
Hi JimJim ,
If you want to create measure, you need to use SELECTEDVALUE() function to wrap your column.
SELECTEDVALUE( Appointments[IsWIP] ) = 1 && SELECTEDVALUE( Appointments[WIP Days] ) < 2, "< 2 Days",
SELECTEDVALUE( Appointments[IsWIP] ) = 1 && SELECTEDVALUE( Appointments[WIP Days] ) > 2, "> 2 Days",
Hi v-eachen-msft , thank you for the tip. I didn't know about the SELECTEDVALUE function.
I managed to create a new column which shows the WIP status, it looks like having a different column for each status was causing the problem.
Thanks to both you and vanessafvg for your help.