Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Need a quick calculation -

I'm struggling to get a simple number.  I'm looking to work out how many individual client names make up my open case count.  The tables are already related.  This is for a visulation where I just want the number of client names that is represented in my open case count.  I feel like I'm missing a simple calculation - just cannot see it.

 

'Account'[Name] = Customer Names

'Cases'[CaseNumbers] = Case Numbers

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    I figured it out.  I was creating the column in the wrong table given the relationship. 

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      I figured it out.  I was creating the column in the wrong table given the relationship. 

      • v-piga-msft's avatar
        v-piga-msft
        Resident Rockstar
        8 years ago

        Hi Anonymous,

         

        It's glad that you have figured it out. :smileywink:

         

        Only thing that you'll have to notice, just always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

         

        Best Regards,

        Cherry