Filtering across tables

Question

Hi,&nbsp;&nbsp;I have created a table in PowerBI to summarise how many appointments each patient has attended, and how many appointments each patient has DNA'd. The table counts rows from my master appointments table based on certain conditions using the following coding:&nbsp;InterventionSummaryTable=VAR SummaryTable = &nbsp; &nbsp; SUMMARIZE(&nbsp; &nbsp; &nbsp; &nbsp; FILTER(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ALLSELECTED('Report Source Appointments'),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NOT(ISBLANK('Report Source Appointments'[Unique ID]))&nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; 'Report Source Appointments'[Unique ID],&nbsp; &nbsp; &nbsp; &nbsp; "Number of Intervention Sessions Attended",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CALCULATE(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; COUNTROWS('Report Source Appointments'),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'Report Source Appointments'[Session Type] = "Intervention" &amp;&amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'Report Source Appointments'[Attendance] IN {"Attended on time", "Attended late but seen"} &amp;&amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NOT(ISBLANK('Report Source Appointments'[End Date]))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; "Number of Intervention Sessions DNA",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CALCULATE(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; COUNTROWS('Report Source Appointments'),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'Report Source Appointments'[Session Type] = "Intervention" &amp;&amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'Report Source Appointments'[Attendance] = "DNA" &amp;&amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NOT(ISBLANK('Report Source Appointments'[End Date]))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; )RETURN&nbsp; &nbsp; SummaryTableWhen I apply an appointment date filter to my master appointments table, the&nbsp;InterventionSummaryTable filters for the Unique ID's that are in the master appointments table, however the&nbsp;"Number of Intervention Sessions Attended" and&nbsp;"Number of Intervention Sessions DNA" columns do not apply the filter and instead I just get a total count for those Unique IDs.I have a relationship established between my Report Source Appointments and&nbsp;InterventionSummaryTable based on Unique ID.&nbsp;Does anybody know how I can ensure that the&nbsp;"Number of Intervention Sessions Attended" and&nbsp;"Number of Intervention Sessions DNA" columns in my InterventionSummaryTable only count filtered data?&nbsp;&nbsp;Thanks!&nbsp;

tommartens · Accepted Answer

Hey&nbsp;naa217&nbsp;,
&nbsp;
this is not possible. Your DAX statement returns a table, a so-called "virtual table". A virtual table will only be "calculated" when the semantic model is refreshed, the same is valid for calculated columns. This is completely different if the DAX returns a scalar value, meaning a measure. A measure will be re-evalutated whenever a user interacts with the model, e.g., changing the selection of a slicer.
&nbsp;
Hopefully, this helps to tackle your challenge.
&nbsp;
Regards,
Tom

Forum Discussion

Filtering across tables

1 Reply

Related content

Filtered table

Can I filter the 1st fact table which then filters a 2nd fact table?

Filtering Table report

How to search specific word in table filter Calculations

Filter on table visual