Forum Discussion

Jimbo1980's avatar
Jimbo1980
Regular Visitor
2 years ago

Need to return value not sum

I have 2 tables in my model:-

  1. 'Requisitions' = Many records
  2. 'ExternalFillRatio' = Unique records by division

I have starting creating a Power Pivot from the 'Requisitions' table using 'Division'. I want to bring in a column from 'ExternalFillRatio' named 'Ratio' to the corresponding divsion. I only want to bring in the value that is matched to the division. I have tried using a column i.e. = RELATED(ExternalFillRatio[Ratio]) but this isn't the answer I am looking for. This creates a grand total in the Power Pivot. All i want is the value e.g (Ratio) that matches the divsion from ExternalFillRatio table.

 

Does anyone know how I can achieve this? Any help is greatly appreciated.

 

 

 

3 Replies

  • aduguid's avatar
    aduguid
    Icon for Memorable Member rankMemorable Member
    2 years ago

    try this calculated column

    Ratio = LOOKUPVALUE(ExternalFillRatio[Ratio], ExternalFillRatio[Division], Requisitions[Division])
    • Jimbo1980's avatar
      Jimbo1980
      Regular Visitor
      2 years ago

      Thank you for your reply. Unfortunately it still creates the same problem.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Jimbo1980 

     

    Maybe you can try to create a virtual table as a variable in the measure or calculated column, then it could be more easier to get the target outcome.

    If possible, please provide your data(exclude sensitive data) or create some sample data, so that we can help you better.

    You can refer the following links to share the required info:

    How to provide sample data in the Power BI Forum

    How to Get Your Question Answered Quickly

     

    Best Regards

    Zhengdong Xu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.