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.
In this chart the values are the correct ones.
To obtain that I've used this solution:
Tot # per category =
CALCULATE(
COUNTROWS( f06_mainneeds ),
ALLEXCEPT(
f06_mainneeds,
f06_mainneeds[choice]
)
)
and then divide this by the total number of surveys, as follows:
% mainneeds by total =
DIVIDE([Tot # per category],[# encuestas])
But it doesn't work when using filters, as I described in the original comment.
Again, any ideas?
Thanks so much
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