Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

DistinctCount with filter.

I have the following data:   Table of Sellers Saller_ID,Client_ID,Region 1,1,North 1,2,North 1,3,South 2,4,North 3,5,West 4,6,East 5,7,East 5,8,East 6,9,South 7,10,South 8,11,South   ...
Need Help
Show and Tell
  • Sean's avatar
    Sean
    9 years ago

    Well you either want Distinct Sellers or you have the data reversed

    (meaning data in Seller_ID column should be in Client_ID and vice versa)

    Distinct Sellers = DISTINCTCOUNT ( 'Sellers Table'[Seller_ID] )
Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

Anonymous

 

Hi Friend, Look the Image Please

 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Vvelarde, I forgot to mention that I need to do it using a measure. Can you help me?

  • Vvelarde's avatar
    Vvelarde
    Community Champion
    9 years ago

    Anonymous

     

    Hi, try this:

     

    TheMeasure = DISTINCTCOUNT(Table1[Id])

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Vvelarde, I edited my data again with more details. 

      • Sean's avatar
        Sean
        Community Champion
        9 years ago

        Well you either want Distinct Sellers or you have the data reversed

        (meaning data in Seller_ID column should be in Client_ID and vice versa)

        Distinct Sellers = DISTINCTCOUNT ( 'Sellers Table'[Seller_ID] )