Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Add non-repeated columns

Hello everyone,

 

In the attached picture, i need to add how much residential and commercial do i have with removing the repeated customer names in Power BI. So that at the end i have 2 residential and 1 commercial. How can i do that?

 

 

Thanks in advance!

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Anonymous Try this:

    Measure=var tempTable=SUMMARIZE('Table','Table'[Customer],'Table'[Vartical])

    return COUNTROWS(tempTable)

     

  • timg's avatar
    timg
    Solution Sage
    4 years ago

    Hi sr12,

    You could do this by opening the Power Query editor, selecting all columns, and then right click and press "remove duplicates". 

    This will remove all duplicate rows based on the columns you selected.

     

    regards,

     

    Tim

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi timg,

      Thank you for your reply,

       

      I dont want to permenantly remove the columns since i need them for other measures, so the table is actually bigger than that.