Need a quick calculation -

[Anonymous]

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

[Ashish_Mathur]

Hi,

Share a dataset and show the expected result.

[Anonymous · Accepted solution]

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

[v-piga-msft]

Hi @Anonymous,

It's glad that you have figured it out. 

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