Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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:(
Solved! Go to Solution.
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
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
The text under each waffle chart is overlapping, please see the below image. Are there any solutions to this please?
Excellent! Thank you so much! That is exactly what i was looking for.
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
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |