topic Re: Calculate proportion of groups using particular item in DAX Commands and Tips

Calculate proportion of groups using particular item

citylights — Wed, 15 Sep 2021 20:18:05 GMT

I have a table structured as below. I would like to show in a table or chart the proportion of "Groups" using each item in the "Item" column. What's the best way to do this? thanks.

Re: Calculate proportion of groups using particular item

Anonymous — Thu, 16 Sep 2021 07:27:08 GMT

[Proportion] = DIVIDE( DISTINCTCOUNT( T[Group] ), COUNTROWS( ALL( T[Group] ) ) )

Re: Calculate proportion of groups using particular item

citylights — Wed, 22 Sep 2021 22:37:49 GMT

thanks Daxer! Your solution worked perfectly for the example I gave. As it turns out though, I oversimplified my example. The table has the majority of its rows filtered out based on several different columns. So it's more like this the picture below. Any help would be appreciated. Thanks.