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
Please correct me if I wrongly understand your point.
In order to find higher than 50% Pareto && highest quantity ->
Please check the below picture if it is what you needed.
Outcome =
VAR newtable =
FILTER (
SUMMARIZE (
ALLSELECTED ( Inventory ),
Inventory[ItemID],
Inventory[Quantity],
"@pareto", [Pareto]
),
[@pareto] >= 0.5
)
RETURN
MAXX ( newtable, Inventory[Quantity] )
Did I answer your question? Mark my post as a solution!
Appreciate your Kudos!!