topic Re: Filter % of total based on other columns in DAX Commands and Tips

Filter % of total based on other columns

K7R-RS8-04 — Wed, 24 Jun 2020 17:12:26 GMT

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!

Re: Filter % of total based on other columns

AntrikshSharma — Wed, 24 Jun 2020 17:29:48 GMT

use ALLSELECTED:

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

Re: Filter % of total based on other columns

Anonymous — Thu, 25 Jun 2020 10:40:14 GMT

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)

Re: Filter % of total based on other columns

K7R-RS8-04 — Thu, 25 Jun 2020 14:49:40 GMT

That worked great - thank you!

Re: Filter % of total based on other columns

K7R-RS8-04 — Thu, 25 Jun 2020 14:50:37 GMT

That worked - thank you!