Forum Discussion
Multiple choice question viz
Hello! I'm working on a survey report with a star scheme design, the center being "a00_encuesta_mixed_movements" table. All the other tables are connected through the "uuid" column. In the survey...
Hi Anonymous
You can try to change the Tot # per category measure to the following
Tot # per category = CALCULATE ( COUNTROWS ( f06_mainneeds ), FILTER ( ALLSELECTED ( f06_mainneeds ), [choice] IN VALUES ( f06_mainneeds[choice] ) ) )Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous
You can try to change the Tot # per category measure to the following
Tot # per category =
CALCULATE (
COUNTROWS ( f06_mainneeds ),
FILTER (
ALLSELECTED ( f06_mainneeds ),
[choice] IN VALUES ( f06_mainneeds[choice] )
)
)
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
That worked!!! Thanks