cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
davidi4524 Member
Member

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

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

 

לכידה.JPG

 

1 REPLY 1
Community Support Team
Community Support Team

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

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.