Filter % of total based on other columns

[K7R-RS8-04]

I have a table that I am trying to apply filters on to show a % of total for a column Account Name. I've tried various SUM, FILTER, DIVIDE expressions but the % total seems to be using the total of all Account Names vs. the few I want to filter out.  Any suggestions on the DAX formulas to help with this would be appreciated.  Thank you!

[harshnathani]

HI @K7R-RS8-04 ,

You can try this measure for Total Percent

total _Percent =

var a = CALCULATE(Sum('Table'[Quantity]))

var b = CALCULATE(Sum('Table'[Quantity]), ALLSELECTED('Table'))

RETURN

DIVIDE(a,b)

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[K7R-RS8-04]

That worked great - thank you!

[AntrikshSharma · Accepted solution]

use ALLSELECTED:

Total Quantity = CALCULATE ( [Total Quantity], ALLSELECTED ( ColumnName ) )

[K7R-RS8-04]

That worked - thank you!