filtering/connection problem

Hi v-ljerr-msft,

First of all, thanks for your reply! :)

I tried it, but after I modified the connection between the Data and Date table to single direction, and then modified the connection Munka1(2) table and Cost table to both direction, and tried to modify the connection between Munka1(2) table and Data table, it gave me this error message:

By the way, in the meanwhile I found a solution which seems to be working. As I mentioned in my original post, I created a column with DAX in the Data table, which is the following: 

Column =

CALCULATE((SUM(data[A4])*2)+SUM(data[A4C])*2)+SUM(data[A3])+SUM(data[A3C])

;ALLEXCEPT(data;data[Service Item No]))

The first part is about calculating all the page volumes in A4 paper size. So, this function gave me for every machine type the page volumes, but if I wanted to filer with it, it did not work with the datas from the Cost table. So, basically, I created the same column in the Munka1(2) table (which is the connection between Data and Cost table). Here it is:

Page Volume on Different Machines =

CALCULATE((SUM(data[A4])*2)+(SUM(data[A4C])*2)+SUM(data[A3])+SUM(data[A3C])

;ALLEXCEPT('Munka1 (2)';'Munka1 (2)'[Service Item No.]))

With this function, I have the same values, and it filters every visualisation and data from the Cost table.

Best regards,

Andris