Forum Discussion

NathanPzi's avatar
NathanPzi
Frequent Visitor
2 years ago
Solved

Dependency problem between 2 tables + sort by column

Hello,   To put you in context, I have 2 tables: Account and Contact. In the "Account" table, I have : - an "Account ID" column - an "Account" column - a "Major Account" column created by Power...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi NathanPzi ,

    I create a sample dataset by myself:

    And I'm not sure what do you mean by "the number of contacts inside", I guess the phrase means the number of different contact IDs for each Major account?
    So I use this DAX:

    Contact_number = DISTINCTCOUNT(Contact[Contact ID])

    Then I create a table visual:


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

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi NathanPzi ,

I create a sample dataset by myself:

And I'm not sure what do you mean by "the number of contacts inside", I guess the phrase means the number of different contact IDs for each Major account?
So I use this DAX:

Contact_number = DISTINCTCOUNT(Contact[Contact ID])

Then I create a table visual:


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