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...
JimJim can you can provide some sample data in text format?
Actually vanessafvg I have added it to onedrive
I would probably change this to a grouping rather than a measure
for eg
WIP Days Group = switch (true(),Appointments[IsWIP] = 1 && Appointments[WIP Days] < 2, "< 2 Days",Appointments[IsWIP] = 1 && Appointments[WIP Days] > 2, "> 2 Days","Not <2 or >2")and then its easy to apply this as a filterHi vanessafvg
Thanks for your reply.
When I add the measure you provided I get the following error message:
A single value for column 'IsWIP' in table 'Appointments' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.
Hi vanessafvg , I have an example report I want to upload but I'm not sure if I am able to do it
