cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
rhborders Regular Visitor
Regular Visitor

Columns not aligning unless aggregated

I am trying to put a column in my table that has a 1:1 relationship between its query and the query that houses the other columns in my table. Whenever I put the column in it does a complete table join and does not align the data. However when I put an aggrate function on the column such as "Sum" the data aligns. Any idea as to why this may be? 

 

1.PNG2.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
rhborders Regular Visitor
Regular Visitor

Re: Columns not aligning unless aggregated

My desired output was to have the CustProdRep column and the Expected revenue column to be populated in both columns of row. The only way I was able to do this was by aggregating one of the columns by appling a function such as sum or count. I ended up resolving this issue by writing a SQL statement that did what I wanted so nothing had to be done in BI. 

View solution in original post

4 REPLIES 4
Super User
Super User

Re: Columns not aligning unless aggregated

Is the example that you are showing where it "aligns" or does not align? I'm not completely sure I understand what you mean by that.

 


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

rhborders Regular Visitor
Regular Visitor

Re: Columns not aligning unless aggregated

The image on the left shows that it aligns when I do a sum on the column. The right image is when there is no aggregate function and they do not align. I do not want to have to do an aggregated function on the column so that I dont not have the extra result row.

Microsoft v-yulgu-msft
Microsoft

Re: Columns not aligning unless aggregated

Hi @rhborders,

 

I waas not clear about your problem. What do you mean "Align"? From above two images, it looks like that column [Expected Revenue] in both of them are align (the diplayed position?). What is your desired output?

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
rhborders Regular Visitor
Regular Visitor

Re: Columns not aligning unless aggregated

My desired output was to have the CustProdRep column and the Expected revenue column to be populated in both columns of row. The only way I was able to do this was by aggregating one of the columns by appling a function such as sum or count. I ended up resolving this issue by writing a SQL statement that did what I wanted so nothing had to be done in BI. 

View solution in original post

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (1,753)