hi

Hello,

also i remove duplicate from disc_type column

so rather filter by disc_type = BG0000117 how can we solve the issue. promotion name will change when create any promotion. would you mind to have a look into this please

thanks

not clear about this. could you pls update your sample data and also let me the expected output?

out put is same that u have given is correct but issue is in your pbix file you filter by BG0000117 

 and i dont want to use filter here as my BG0000117  will be change to BG0000118, BG0000119, BG0000120 etc etc ......

i have duplicate value in disc_type and invoice column and i remove null, remove duplicates, remove blank then create relationshio with sales table invoice_no and new Table Invoice_no many to one its ok but the result is not comes , result shows 

 but i want to see 

like this

thnakx

you don't filter in your table, you should filter in the filter visual. 

i remove empty values in the table. maybe you only provide the data with BG0000117 , if you provide more data BG0000118 or BG0000119. These data will also display in the new table.

basicly you can see the disc_type list in the filter visual in your last screenshot. Then you select the disc type to show the corresponding output.

updated the sample .pls see the attachment below

Hello ryan_mayu 

Here i have given more sample file to pbix file

please use this. 

https://drive.google.com/drive/folders/1-WQ9JQ36Rb0VqprPY6cGoWHxepdamidg?usp=drive_link

instead of filtering

thx

don't know why ,i can't open the link, you can just skip the filter step ,just remove duplicates