Forum Discussion

AGScottThompson's avatar
AGScottThompson
Frequent Visitor
4 years ago
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...
Need Help
  • SpartaBI's avatar
    SpartaBI
    4 years ago

    AGScottThompson try this:

     

    ClientCount = DISTINCTCOUNT('Real Estate Final'[Client])
ALLClientCountInDescription = CALCULATE([ClientCount],REMOVEFILTERS('Real Estate Final'), VALUES('Real Estate Final'[Description]))
ClientCountPCT = [ClientCount]/[ALLClientCountInDescription]

     





          

    Showcase Report – Contoso By SpartaBI

AGScottThompson's avatar
AGScottThompson
Frequent Visitor
4 years ago

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's avatar
    SpartaBI
    Community Champion
    4 years ago

    AGScottThompson I need more info 🙂 
    You can PM me to show me on zoom?