Need help on DAX

[pprasadravi]

Hi,

I have a situation where I want to compare the product price by customer and display the results based on from selected batch and To selected batch as shown below. 

I have three different scenarions to complete this report.

1.  Product purchased From Selected Batch but not in To Selected Batch

2. Product purchased To Selected Batch but not in From Selected Batch

3. Product purchased  From and To Selected Batches but the cost is different.
Source Data:

Report

Could you please give me an idea on how I can implement the solution?

Thanks

Ravi Potturi

[pprasadravi]

Hi amitchandak,

Thank you so much for the quick response. I think suggested solution should work for me. I will check it and let you know if I see any issues.

Ravi Potturi

[amitchandak]

@pprasadravi , for that, create independent table using distinct values of Batch 

Need of an Independent Table in Power BI: https://youtu.be/lOEW-YUrAbE

Then you can have measure like

calculate(Sum(Table[Cost]), filter(Table, Table[Batch] in values(Batch1[Batch]) &&  not(Table[Batch] in values(Batch2[Batch]) ) ) )

[pprasadravi]

Hi Amit Chandak,

I am exremly sorry for the delayed response.

I think independent table many not work for my scenario. I think I need in memory table that should holds the  data based batch ID selection in the slicer. 

I followed article https://www.sqlbi.com/articles/understanding-data-lineage-in-dax/ but no success. 
Does it make sense?

Thanks

Ravi Potturi