Forum Discussion
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...
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.
Anonymous here is a sample of my data
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.