Add non-repeated columns

[Anonymous]

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!

[timg]

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]

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.

[Anonymous]

@Anonymous Try this:

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

return COUNTROWS(tempTable)