Trying to create a percentage column based on the TotalCount Total.

[mangeski]

For example, I would like the next measurement column on the right side to show the % of that row from the Total from the TotalCount column. So COMPASS would be 7/100. 

I've tried a couple of formulas from posts in the search but with no success.. Any help would be great. Thanks team.

[Ashish_Mathur]

Hi,

You may also use visual calculations.

[ryan_mayu · Accepted solution]

@mangeski 

why COMPASS is 7/100 , not 7/11311?

Besides creating a new measure, you can also add the measure or column to the table again . Then show value as percentage of grand total

[mangeski]

Yes, I meant 7/11311. Sorry about that typo for the ones that mentioned it. Thank you for your help. I'm pretty new to BI and this forum. You guys are great.

[ryan_mayu]

you are welcome

[MasonMA]

@mangeski 

Hi, 100 in 'COMPASS would be 7/100' might be a typo in your message.

You may try 

Percentage of Total =
VAR RowCount = SUM('Table'[TotalCount])
VAR TotalCount = CALCULATE(SUM('Table'[TotalCount]), ALL('Table'))
RETURN
DIVIDE(RowCount, TotalCount, 0)

This will give you decimal numbers, you can format with power bi UI to percentage.