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

 

 

(it looks like that my relation does not exist, but if I replaced it by a double sens relation ship, it works
The issue with a double sens, I lost the blank value

 

Any idea of what I can do to solve this issue?

 

Need Help

3 Replies

  • 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