Jimbo1980Regular Visitor2 years agoNeed to return value not sum I have 2 tables in my model:- 'Requisitions' = Many records 'ExternalFillRatio' = Unique records by division I have starting creating a Power Pivot from the 'Requisitions' table using 'Division'...Show More
aduguidMemorable Member2 years agotry this calculated columnRatio = LOOKUPVALUE(ExternalFillRatio[Ratio], ExternalFillRatio[Division], Requisitions[Division])
Jimbo1980Regular Visitor to aduguid2 years agoThank you for your reply. Unfortunately it still creates the same problem.
Related contentMeasure returning incorrect valueDate Different return wrong valueMAXX Returning duplicate valuesReturn "Specific value" from table 1, if not found, return value from table 2Create Measure to Return Highest Value
