Filter interactions do not work without a measure on table visuals

[daveedd]

Hi all,

QQ.  I have Case records with 10 different date fields relating to different parts of the Case lifecycle.  I recently built out a neutral date field so that I could show how many Cases were opened, closed and more all each month on the same chart.  

I have set ups like a bar chart or other visual and a table which was simply a list of Case reference numbers.  Selecting a value on the bar chart filters the table to show only the relevant cases.

Since implementing the new date system I have to include a metric in the table as well, eg cases opened, to make the filtering work.

Appreciate it might be difficult without going into full details of the set up, but does anyone have any ideas of what could break the filter interation in this way?

Many thanks

[MFelix · Accepted solution]

Hi @daveedd 

In this case of multiple date in the same table you must create a calendar table (that you already have) and created relationship between the Calendar table and all the columns you need to make the calculations, you will get an active relationship, and n inactive relationships.

Then you need to create a metric for each column that has inactive relationship:

Count of date = CALCULATE( COUNT(Table[Column], USERELATIONSHIP(Table[DateColumn], Calendar[Date]))

Now you must use the calendar table has your axis and the measures on your visualization.

Check my blog post below (is in portuguese but the google translate works pretty well)

https://pbiportugal.com/2020/08/27/multiplas-relacoes-entre-tabelas/