Forum Discussion
Bokazoit
4 years agoContinued Contributor
Measure to remove (empty) from Distinct count
I have this datamodel with cross filter set to Both way joins, since its a questionary with multiple choice answers. I find that data model as a solution in this forum: When I need to show ...
v-jingzhang
4 years agoCommunity Support
Hi Bokazoit
Maybe we can think the other way around. Calculate the dictinct count of empty ones and the distinct count of all values in advance. Then substract the former one from the latter one.
Best Regards,
Community Support Team _ Jing