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
That is almost working for me, but I need to add 2 filters in. I tried
ALLClientCountInDescription = CALCULATE([ClientCount],REMOVEFILTERS('Real Estate Final'),VALUES('Year'[Year]) ,VALUES(RealEstate_TIVBandSort[Description]) )
But it does not apppear to be working.
- SpartaBI
Community Champion
AGScottThompson I need more info 🙂
You can PM me to show me on zoom?