trying to create a sum measure that will be effected from filter

[davidi4524]

hi, i have a data that combined from 3 tables that have a relationship between

1.JUST_TRANSORDER_COST

2.TRANSORDER_WITH_COST

3. SERNUMBERS

THE DATA LOOK LIKE THIS:

SERNUM - TOTAL ASSEMBLY_COST - COST - DOCUMENTNUM

IN THE TABLE VISUAL I GOT A SUM OF "TOTALASSEMBLY_COST" OF ALL THE RECORDS.

I HAVE A SLICER FOR THE "DOCUMENTNUM" WICH I SELECT ONLY ONE DOCUMENTNUM.

I SEE IN THE TABLE JUST THE "TOTALASSEMBLY_COST" THAT RELATED TO THE SELECTED DOCUMENTNUM,BUT IN THE BOTTOM SUM. I GET THE NUMBER OF ALL THE "TOTALASSEMBLY " OF ALL THE TABLE.

HOW DO I CAN CREATE A MEASURE/COLUMN THAT WILL BE EFECTED FROM THE SLICER?

THANKS

[v-yulgu-msft]

Hi @davidi4524,

Could you please share sample data in source table? I need to know the structure of these three tables and their detailed rows and the relationships between them so that I can try to reproduce your scenario on my side.

Regards,

Yuliana Gu