ALLSELECTED(), but with one exception? Is this sorcery possible?

[AliceW]

Hello everyone,

I have this big table and I created one measure to get the % from total.

From Total =

divide(

   [Amount],

    calculate([Amount],ALLSELECTED()

))

However, I have this Date table, whose column Year I use in a matrix.

I'd like the % to be 100% for each year.

At the moment, I get 100% for all years.

The expected result:

Value	2022	2023
Fruits	45%	30%
Vegs	55%	70%
Total	100%	100%

Does anyone know how to solve this, please?

Thanks,

Alice

[v-cgao-msft · Accepted solution]

Hi @AliceW ,

Please try this:

From Total = 
DIVIDE(
    [Amount],
    CALCULATE([Amount], ALLSELECTED(),VALUES('Calendar'[Year]))
)

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[AliceW]

Thank you so much, Gao! It works great!

[AliceW]

Hi Sergej,

I'd like that each Year column gets its own 100%.

Like you get when displaying an amount as '% of column total'. Yes, this is the best example. The only reason why I'm NOT using this solution is because I'm bringing this measure into a Switch measure later on.

I hope it's clear and you can find a solution :0)

Thank you for reading,
Alice

[sergej_og]

Hey Alice,
like this, right?

If yes, try this:

% Part = 
VAR SalesCategory = 
    CALCULATE(
        [your_SUM_measure],
        ALLSELECTED(yout_table[Category])
    )

RETURN
DIVIDE([your_SUM_measure], SalesCategory)

Regards
Sergej

[sergej_og]

Hey Alice,
not clear to me what is your target layout.
What result would you like achieve?

Can you pls provide a Screen with your target and discription to that.