Forum Discussion
Clustered Chart Group Total
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
4 Replies
- SpartaBI
Community Champion
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 SpartaBI - SpartaBI
AGScottThompson 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
AGScottThompson I need more info 🙂
You can PM me to show me on zoom?
