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.