Forum Discussion

jcastr02's avatar
jcastr02
Post Prodigy
6 years ago
Solved

100% clustered chart

How can I get a 100% clusterd chart.  I'd like the same data on the left to be look like on the right.  However, I'd like for it not to be % of grand total, should be   numbers of what we see on left...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi jcastr02 ,

     

    If i understand you correctly, you can use COUNT() function. Please refer to the below measure.

    Measure 3 = CALCULATE(COUNT('Table'[Column2]),ALLEXCEPT('Table','Table'[Column1],'Table'[Column2]))/CALCULATE(COUNT('Table'[Column2]),ALLEXCEPT('Table','Table'[Column2]))

    Result would be shown as below.

     

     

    Best Regards,

    Jay

    Community Support Team _ Jay Wang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

jcastr02's avatar
jcastr02
Post Prodigy
6 years ago

Anonymous    Hi Jay, this is how I have it currently.  I'd like it to be in your sample where both Bars for A - total 100%,  both bars for B total 100%, and both bars for C total 100%.....  VS. All bars totalling 100%

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi jcastr02 ,

 

Modify the measure as below.

Measure = CALCULATE(SUM('Table'[value]),ALLEXCEPT('Table','Table'[ID],'Table'[type]))/CALCULATE(SUM('Table'[value]),ALLEXCEPT('Table','Table'[ID]))

If i misunderstood your meaning, please show your expected out put to us.

 

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • jcastr02's avatar
    jcastr02
    Post Prodigy
    6 years ago

    Anonymous     I don't necessarily have a "value" column, I just have a column with responses Yes, No, Not applicable.  I tried to create a custom column with the value of "1" for each of the responses.  I did this measure, but continues to have errors, any help is appreciated.  

    • jcastr02's avatar
      jcastr02
      Post Prodigy
      6 years ago

      Anonymous here is a sample of my data

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi jcastr02 ,

         

        If i understand you correctly, you can use COUNT() function. Please refer to the below measure.

        Measure 3 = CALCULATE(COUNT('Table'[Column2]),ALLEXCEPT('Table','Table'[Column1],'Table'[Column2]))/CALCULATE(COUNT('Table'[Column2]),ALLEXCEPT('Table','Table'[Column2]))

        Result would be shown as below.

         

         

        Best Regards,

        Jay

        Community Support Team _ Jay Wang

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.