How to get percentage of total rows when grouping by a column?

[Anonymous]

I have the below table:

Person	Inventory
A	Red
B	Red
A	Blue
A	Yellow
B	Blue
C	Yellow

I have a report that allows me to filter by 'Person'. When I select a 'Person', I would like a Card to display the percentage of total inventory that 'Person' has.

For example, when 'A' is selected it would show 50%, when 'B' is selected it would show 67%, etc.

How would I go about doing this?

[v-ljerr-msft]

Hi @Anonymous,

Have you tried the solution provided above? Does it work in your scenario? If the solution works, could you accept it as solution to close this thread?

If you still have any question on this issue, feel free to post here. 

Regards

[Sean · Accepted solution]

This Measure should do it

Measure =
DIVIDE (
    COUNTA ( 'Table'[Inventory] ),
    CALCULATE ( COUNTA ( 'Table'[Inventory] ), ALL ( 'Table' ) ),
    0
)

[Anonymous]

Perfect, it looks like that works. 

I had been using this which was working:

Measure = COUNTROWS('Table') / COUNTROWS( ALL('Table') )

Yours does the trick too. Thanks for the help.