Forum Discussion

vvibhakar's avatar
vvibhakar
Frequent Visitor
8 years ago
Solved

Distinctcount of values from multiple columns.

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...
  • v-yuta-msft's avatar
    v-yuta-msft
    8 years ago

    Hi vvibhakar ,

     

    Click Query Editor->Transform, click on column [Vendor1] [Vendor2] [Vendor3], then click Unpivot.

     

    After close and applied, create a measure using DAX like this:

    Number = DISTINCTCOUNT(Table1[Value])

    Regards,

    Jimmy Tao

     

  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    You may refer to my solution in thi file.

     

    Hope this helps.

     

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi,

 

You may refer to my solution in thi file.

 

Hope this helps.