Calculate % of total at attribute level (not grand total)

[smileamile2]

I am trying to create a measure for % of total by Site. % of Grand Total can use built-in functionality so no work there, but what is the logic to break it down to an attribute level?

Tried this but it doesn't work: DIVIDE(SUM('Main'[Amount]),CALCULATE(SUM('Main'[Amount]),ALLEXCEPT('Main','Main'[Site])))

[v-jayw-msft]

Hi @smileamile2 ,

I used your formula and get the result as shown in your screenshot. What is the expected result?

Best Regards,

Jay

[selimovd]

Hey @smileamile2 ,

can you show your result in Power BI?

The values for % of total by site look good, but I guess that's Excel.

What is the result for the calculate-part:

CALCULATE(SUM('Main'[Amount]),ALLEXCEPT('Main','Main'[Site]))

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[smileamile2]

Most results are 0%, only adding up to a total of 9.71%. I only included the excel spreadsheet as the desired outcome sample.