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     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.