Forum Discussion
Need 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'...
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.