Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
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
Proud to be a Super User!
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.
@sr12 Try this:
Measure=var tempTable=SUMMARIZE('Table','Table'[Customer],'Table'[Vartical])
return COUNTROWS(tempTable)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |