Market Share Dax to the respective category

[Aysh_2104]

I am working on the Market Share dax that works on the with the respective category , also which could work based on filters. Below is the sample in excel.

[Aysh_2104]

Hello @v-xiaotang ,

The Market Share dax shows the correct numbers for both all and respective category, but what is required is when i select all it shouldn't show me the volume/ total volume , it should show me the volume/respective category volume.

	Volume	Market Share
apple	3	16.67%
banana	15	83.33%
carrot	5	33.33%
tomato	10	66.67%

[v-xiaotang]

Hi @Aysh_2104 

I find an article, and you can take a look at it, How to Get Your Question Answered Quickly https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523#M6071...

hope it helps!

Best Regards,

Community Support Team _Tang

[v-xiaotang]

Hi @Aysh_2104 

in your picture, there are 3 parts, [category1/ item A / Item A1] & [category A B C] & [Item A B C]. but what's your expected result, could you add more details about it?

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[Aysh_2104]

Hi @v-xiaotang ,

I select the respective category or overall category the output should give me the same. overall category should still divide the item with its category total not the over all total.

[v-xiaotang]

Hi @Aysh_2104 

it seems possible, but information is not really enough to go on, could you post some sample data and its expected result? not sure the structure of your data. 

Best Regards,

Community Support Team _Tang