Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Need help on DAX

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 sc...
Need Help
Show and Tell
amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , 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]) ) ) )

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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