waffle chart with survey responses

[Viola]

Hello everyone, 

I am currently trying to display my survey results using waffle chart. My responses are in text format therefore i need to add a new coulmn that will calculate the values of each response, what is the formula for that? I have tried several and nothing works, i am able to calculate one value at the time, when adding new measure to the same column i get an error? Anyone know how to solve that issue ? 

I would higly appreaciate as i am stuck with it 2nd day already:( 

[v-haibl-msft · Accepted solution]

@Viola

I do not know about your data table, so I create a test table like below. In such scenario, we can create two measures to calcuate the responses for each type and all types.

Measure_Count = 
CALCULATE ( COUNTROWS ( Table1 ), ALLEXCEPT ( Table1, Table1[Response] ) )

Measure_All = 
CALCULATE ( COUNTROWS ( Table1 ), ALL ( Table1 ) )

Best Regards,
Herbert

[Anonymous]

@v-haibl-msft 

The text under each waffle chart is overlapping, please see the below image. Are there any solutions to this please?

[Viola]

Excellent! Thank you so much! That is exactly what i was looking for.

[v-haibl-msft]

@Viola

You can mark the right answer as solution so that others who have the same problem can find the correct solution quickly.

Best Regards,
Herbert