topic calculate percentage by category in DAX Commands and Tips

calculate percentage by category

Anonymous — Fri, 24 Jun 2022 15:34:01 GMT

HI i am having a dataset with grades of all the students and i need them as percentage by gender that is male or female.

The problem is when i am plotting the graphs seperately, each graph is individually summing their columns to 100%.

But when combined into a single stacked column chart the filters are working on the visual and disrupting the graph.

below is the sample dataset:

When the above two category graphs are combine i need them to stay as they are without interacting with each other.

Any suggestions and help will be really appreciated.

Thanks,

Sai

amitchandak — Sat, 25 Jun 2022 06:41:36 GMT

Anonymous , You can create a measure like

Divide( Sum(Table[Value]), Calculate(Sum(Table[Value]), removefilters(Table[gender])) )

Anonymous — Wed, 29 Jun 2022 06:00:15 GMT

Hi Anonymous ,

I suggest you to try Cluster column chart instead of Stacked column chart to combine two visuals.

You can create a visual by Cluster column chart as below.

Best Regards,
Rico Zhou

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