Cross Filtering not working as expected.

Question

Hi Guys,&nbsp;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 &gt;2 days. I have the following measures on my report:&nbsp;Total WIP = CALCULATE(COUNTROWS(Appointments),Appointments[IsWIP]=1)Total WIP &lt; 2 = CALCULATE(COUNTROWS(Appointments),Appointments[IsWIP]=1,Appointments[WIP Days] &lt;=2)Total WIP &gt; 2 = CALCULATE(COUNTROWS(Appointments),Appointments[IsWIP]=1,Appointments[WIP Days] &gt;2)&nbsp;I have a matrix like this one which shows the number of WIP of each area and split of &lt; 2 days and &gt; 2 days&nbsp;&nbsp;I then have a table which shows the details of each row, I would like to be able to see the four rows that are &lt; 2 days or the two rows that are &gt; 2 days. But when I select the values 4 or 2 it filters the table to show all six rows. I'm guessing that I haven't modelled my data correctly.&nbsp;&nbsp;Any help would be appreciated.

vanessafvg · Answer

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 filter

jimjim · Answer

Hi&nbsp;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.&nbsp;Thanks to both you and&nbsp;vanessafvg for your help.

jimjim · Answer

Actually&nbsp;vanessafvg&nbsp;I have added it to onedrive&nbsp;https://1drv.ms/u/s!ArazqhFmvkSJlgp8E5ljt0X_1CXE?e=qHp0Wl&nbsp;

v-eachen-msft · Answer

Hi JimJim&nbsp;,
&nbsp;
If you want to create measure, you need to use SELECTEDVALUE() function to&nbsp;wrap your column.
SELECTEDVALUE( Appointments[IsWIP] ) = 1 &amp;&amp; SELECTEDVALUE( Appointments[WIP Days] ) &lt; 2, "&lt; 2 Days",
SELECTEDVALUE( Appointments[IsWIP] ) = 1 &amp;&amp; SELECTEDVALUE( Appointments[WIP Days] ) &gt; 2, "&gt; 2 Days",
&nbsp;

vanessafvg · Answer

JimJim&nbsp; can you can provide some sample data in text format?

Forum Discussion

Cross Filtering not working as expected.

7 Replies

Related content

Hierarchy Filter with search not working as expected

Filter not working as expected

dbt job schema not working as expected

Semantic Model not working as expected

Power BI: Model is not working as expected