Forum Discussion
Solved
Clustered Chart Group Total
How do you calculate a percent based on a group? I am trying to figure out the percentage of each value in a group in a cluster chart. Each Bar should be the percentage relative to the group not the...
AGScottThompson try this:
ClientCount = DISTINCTCOUNT('Real Estate Final'[Client]) ALLClientCountInDescription = CALCULATE([ClientCount],REMOVEFILTERS('Real Estate Final'), VALUES('Real Estate Final'[Description])) ClientCountPCT = [ClientCount]/[ALLClientCountInDescription]
In case it answered your question, please accept the solution to help other members find it. Appreciate Your Kudos.
SpartaBI Logo
Visit SpartaBI website Visit SpartaBI Linkdin Visit SpartaBI Facebook
Showcase Report – Contoso By SpartaBIAGScottThompson make sure the Year Column comes from the right table
SpartaBI
Community Champion
Community ChampionAGScottThompson make sure the Year Column comes from the right table