Forum Discussion
Return Specific Value from Measure
Hi All, I have a running total percentage messure [Pareto] based on an inventory table I want to return the largest value from the [Inventory Value] messure from the ItemID > 0.50 for messure...
Hi EnrichedUser ,
What is the relationship between your example and [Inventory Sample]? The two tables seem to be different.
If I understand correctly, you want to create a measure named 'Pareto'. How do you get the percentage of your Pareto measure? Is Inventory Value divided by the sum of all Inventory Values?
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.