Forum Discussion

Cookistador's avatar
Cookistador
Icon for Super User rankSuper User
2 years ago

Count with 1-n relationship

Hi everyone,   I'm facing a weird issue with my data model, I simplified it to isolate the tables which caused the error   but when I tried to make a count, it returns the following error ...
Need Help
v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity Support
2 years ago

Hi, Cookistador 

 

I simply modelled some data.

Measure = CALCULATE(COUNT(Tag[leadid]),ALLEXCEPT(Tag,Tag[Tag]))

Is this the result you expect? Please see the attached document.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Cookistador's avatar
Cookistador
Icon for Super User rankSuper User
2 years ago

Thank you for your help
Yes it looks like what I need, but there is a way to show also values without tag?
So also counting blank values