Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Issue with allocating quantity based on match in another column

Hello Community!   In a previous post I had the following problem:    I have a table containing a list of article codes that represent tyres or wheelsets. All have a forecasted quantity. The whee...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Try a new measure for total quantity and check

     

    sum(Table[Quantity]) + calculate(sum(Table[Quantity]), filter(allselected(Table), Table[Contains Tyre] = max(Table[Article Code])))

     

     

    or

     

    sum(Table[Quantity]) + calculate(sum(Table[Quantity]), filter(allselected(Table), Table[Contains Tyre] = max(Table[Article Code])))+0

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
5 years ago

Hi, Anonymous 

I am not sure if I understood correctly your question, but I suggest creating a new table.

Please check the below picture and the sample pbix file's link down below.

 

 

 

https://www.dropbox.com/s/rmvida7yz92x0zg/timfrikkee.pbix?dl=0 

 

 

Hi, My name is Jihwan Kim.

 

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

 

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM