Adjusting Values With only a Measure

[edtheiii11]

Hi,

I'm not sure on how exactly to word my question, so I'll just give an oversimplified example.

I have a table that looks like this:

Fruit	Quanity
Apple	7
Orange	8
Banana	4
Antifruit	21

But I would like a measure that outputs something like this, where the amount listed above for Antifruit is the total, and Antifruit is given the remainder:

Fruit	Quantity
Apple	7
Orange	8
Banana	4
Antifruit	2
Total	21

Is it possible to do this with only a measure?  I.e. not modifying the tables in M or creating a calculated column.

The model I'm working off of is obviously much more complex than this, so let me know if you have any questions.

Thanks!

[parry2k]

@edtheiii11 maybe something like this

Sum Quantity = SUM ( Table[Quantity] )

Sum Qty Final =
IF ( SELECTEDVALUE ( Table[Fruit] ) = "Antifruit", 
    CALCULATE ( [Sum Quantity], ALLSELECTED ( Table ) ),
    [Sum Quantity]
)

Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. If you can spend time posting the question, you can also make an effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!