Top 10 with % over another column

[pedroccamaraDBI]

Hello all. Hope you're all good.
I have this visual that show me the top 10 value for each SKU.

Now, i would like to have another column that show me what is the % of those values for each UNIT. 
I've tried to find out the total of each unit but it's not working...maybe because of the context. Don't really know...and this measure doesn't work . It shows the same value as VALUE.
Measure = CALCULATE ([Total Value], ALL (Table[Unit] ))
Can any of you help me?
Thank you all

[Whitewater100]

Hi:

It's difficult to answer in the best way when theri is no pbix however,

You can first make a measure to sum up the values;  Total Qty= SUM(TableName[Values]) If you are doing this as a calc col in a tablethis same formula Tot Qty = SUM(TableName[Values])  will give you the bottom line total for all units. 

The SHARE Measure can be 

DIVIDE(SUMX(TableName, [Tot Qty]),

SUMX(ALLSELECTED(TableName), [Tot Qty])

If this doesn't work, please share file.(or sample). Hope this helps.

Then can do DIVIDE(TableName[

The divide function can give you the percents.

[pedroccamaraDBI]

Hello @Whitewater100 
Thank you for your answer.

Before the share measure, i need to first calculate the total value for each unit, regardless the context, except the date filter.
And that's the measure i need help

Thank you very much

[Whitewater100]

This measure?

Total Qty= SUM(TableName[Values])

Total Qty All Items = CALCULATE([Total Qty], REMOVEFILRERS())

[pedroccamaraDBI]

Hi @Whitewater100 
The idea is to have all Qty for each unit that exists in the visual. Your measure didn't work and i've tried also 

CALCULATE( [Qt], ALLSELECTED( UN )) but it didn't work. It showed me the total for all units. I want the total for each unit.

[Whitewater100]

Hello:

Please see my example file. I wll attach due to a few steps involved.

https://drive.google.com/file/d/1eU_FZGevQG7JVfDy0yl5cDaQ1P0ZFp-4/view?usp=sharing 

[pedroccamaraDBI]

@Whitewater100  could you please let me know which file is it and where is it?

[Whitewater100]

Hi:

I put it in my Google Drive. Is this link working?

https://drive.google.com/file/d/1eU_FZGevQG7JVfDy0yl5cDaQ1P0ZFp-4/view?usp=sharing

[pedroccamaraDBI]

Yes but It's showing me this...

[pedroccamaraDBI · Accepted solution]

This is the solution i came up with

CALCULATE( [Value], ALLEXCEPT( Product, Producto[Unit]))