Forum Discussion

vvibhakar's avatar
vvibhakar
Frequent Visitor
8 years ago
Solved

Distinctcount for values from multiple colums

Hello, I am trying to analyse all the sourcing projects. We have 10 different columns for each Vendor and its price. I want to have a measure which shows me distinct count of all the vendors combi...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    vvibhakar

     

    May be a MEASURE like

     

    Measure =
COUNTROWS (
    DISTINCT (
        UNION (
            VALUES ( TableName[Vendor 1] ),
            VALUES ( TableName[Vendor 2] ),
            VALUES ( TableName[Vendor 3] )
        )
    )
)

     

sqlguru448's avatar
sqlguru448
Helper III
8 years ago

please try below

 

= DISTINCTCOUNT(Vendor1) +  DISTINCTCOUNT(Vendor2) +  DISTINCTCOUNT(Vendor3)

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    8 years ago

    vvibhakar

     

    May be a MEASURE like

     

    Measure =
COUNTROWS (
    DISTINCT (
        UNION (
            VALUES ( TableName[Vendor 1] ),
            VALUES ( TableName[Vendor 2] ),
            VALUES ( TableName[Vendor 3] )
        )
    )
)

     

  • vvibhakar's avatar
    vvibhakar
    Frequent Visitor
    8 years ago

    I had tried already, but it adds up the distinct count. In the given example, the final value still shows 21.