topic Re: Top 10 with % over another column in DAX Commands and Tips

Top 10 with % over another column

pedroccamaraDBI — Tue, 08 Feb 2022 18:00:18 GMT

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

Re: Top 10 with % over another column

Whitewater100 — Tue, 08 Feb 2022 18:23:23 GMT

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.

Re: Top 10 with % over another column

pedroccamaraDBI — Tue, 08 Feb 2022 18:48:32 GMT

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

Re: Top 10 with % over another column

Whitewater100 — Tue, 08 Feb 2022 19:54:05 GMT

This measure?

Total Qty= SUM(TableName[Values])

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

Re: Top 10 with % over another column

pedroccamaraDBI — Wed, 09 Feb 2022 12:09:31 GMT

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.

Re: Top 10 with % over another column

Whitewater100 — Wed, 09 Feb 2022 14:21:56 GMT

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

Re: Top 10 with % over another column

pedroccamaraDBI — Wed, 09 Feb 2022 15:27:55 GMT

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

Re: Top 10 with % over another column

Whitewater100 — Wed, 09 Feb 2022 16:47:52 GMT

Hi:

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

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

Re: Top 10 with % over another column

pedroccamaraDBI — Thu, 10 Feb 2022 09:12:49 GMT

Yes but It's showing me this...

Re: Top 10 with % over another column

pedroccamaraDBI — Thu, 10 Feb 2022 10:40:18 GMT

This is the solution i came up with

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