Showing % of value within each group on a visualisation

[nickschw]

Hi there,

in the picture below you can see that each year in each product group (e.g.: T Shirts) is shows as the percentage OVERALL.

I have used (count of) ean as value, showing the value as percent of grand total

However, I want it each value to show as the percentage of just the group

E.G. On T shirts for 2021 it says 12,35%. That is the percentage compared to the entire data in the graph.

I want to see the percentage of the year based on the product group t shirts.

Hope this makes sense 

regards

[v-rongtiep-msft · Accepted solution]

Hi @nickschw ,

Create a measure.

result = 

SELECTEDVALUE('product'[ean])/CALCULATE(SUM('product'[ean]),FILTER(ALL('product'),'product'[product]=SELECTEDVALUE('product'[product])))

Best Regards

Community Support Team _ polly

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

[VahidDM]

Hi @nickschw 

If you used a measure to find that %, you need to add ALLEXCEPTED code to your measure -ALLEXCEPTED(table,table[product group])

https://docs.microsoft.com/en-us/dax/allexcept-function-dax

https://www.youtube.com/watch?v=ubrv53XaiFI

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

Appreciate your Kudos✌️!!

https://www.youtube.com/watch?v=ubrv53XaiFI

[nickschw]

hi,

I have not used a measure for the %. I have "EAN" as value, using count and showing percent of grand total (in the visualization tab). The problem I would see with your soluton, is that I would need a measure for every single product group.

Is there an easier solution? One with just one measure?

regards