Forum Discussion

biswad's avatar
biswad
Icon for Advocate I rankAdvocate I
2 years ago
Solved

How to count unique Values in a duplicate rows

Hi Friends,    I'm working on Power BI report and I have a table which contains list of Organisations and the roles within each of the organisation as below. I would like to count the "Total_Role" ...
powerbi
  • DimaMD's avatar
    DimaMD
    2 years ago

    biswad  add ID to measure 

    = SUMX( SUMMARIZE('table','table'[Organistation],'table'[ID],'table'[Total_Role]),[Total_Role])

     

DimaMD's avatar
DimaMD
Icon for Solution Sage rankSolution Sage
2 years ago

biswad  add ID to measure 

= SUMX( SUMMARIZE('table','table'[Organistation],'table'[ID],'table'[Total_Role]),[Total_Role])

 

biswad's avatar
biswad
Icon for Advocate I rankAdvocate I
2 years ago
Thank you, this works, I think I have an issue with my data. but I got an idea how to achieve it through your helpful query.