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

SpartaBI's avatar
SpartaBI
Community Champion
4 years ago

AGScottThompson make sure the Year Column comes from the right table