Forum Discussion

RachelS0815's avatar
RachelS0815
Regular Visitor
4 years ago
Solved

Lookup Values on Multiple Criteria Returns Different Values Under Same Condition

Hello,   I am new in DAX, and I try to look up a value under multiple conditions. However, it returns the correct value in some columns but not all. But the criteria is the same. I try to circle ba...
  • RachelS0815's avatar
    RachelS0815
    4 years ago

    Hi Kalyj,

     

    Thanks for you reply. I finally found out the issue yesterday that Power BI sum the values when I added. Once I removed the sum, it is fixed. 

     

    Regards,

     

    Rachel

v-yanjiang-msft's avatar
v-yanjiang-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi RachelS0815 ,

I create a sample and can't reproduce your problem. Is QOH VALUES a calculated column? Did the two tables have relationship, in which column did they relate. What's the difference between rows got the correct value and rows got the wrong value.

Best Regards,
Community Support Team _ kalyj

RachelS0815's avatar
RachelS0815
Regular Visitor
4 years ago

Hi Kalyj,

 

Thanks for you reply. I finally found out the issue yesterday that Power BI sum the values when I added. Once I removed the sum, it is fixed. 

 

Regards,

 

Rachel

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi RachelS0815 ,

    Glad your problem is solved. If you don't have other problems, would you please accept your answer as the solution, then we are able to close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.

    Best Regards,
    Community Support Team _ kalyj