Forum Discussion

JimJim's avatar
JimJim
Icon for Responsive Resident rankResponsive Resident
6 years ago

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...
Need Help
v-eachen-msft's avatar
v-eachen-msft
Icon for Community Support rankCommunity Support
6 years ago

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",

 

JimJim's avatar
JimJim
Icon for Responsive Resident rankResponsive Resident
6 years ago

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.