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 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

 

 

Need Help
Show and Tell

3 Replies

  • 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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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