Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
swise001
Continued Contributor
Continued Contributor

Aggregation Table - Issue selecting detail column

I've created a direct-query aggregation table with 3 aggregations on DateKey

 

Sum of QTY

Sum of Sales

Count of Sales: 

Here is an image of the agg table creation (done in Power Query)

swise001_0-1600271384178.png

 

Once in the model - I'm trying to set the appropriate aggregations 

swise001_1-1600271490812.png

 

swise001_3-1600271542345.png

I am trying to setup SumQty to reflect the Sum of the Qty column, 

It would have to same structure as SalesSum - except - with "Qty"  in the Detail column instead of Sales. 

However, when I open the drop down menu to select "Qty" it's not available. 

swise001_4-1600271641434.png

Any ideas why the Qty column column would be 'greyed' out for the SumQty detail column?

 

 

1 ACCEPTED SOLUTION
swise001
Continued Contributor
Continued Contributor

The source table data type was ultimately the source of the issue. 

 

I updated the source View to cast "Qty" in the same format as Sales.  Once updated, the aggregation table then allowed me to select Qty for that column.  

View solution in original post

4 REPLIES 4
Watsky
Solution Sage
Solution Sage

@swise001  if you highlight over the QTY option in the drop down it should give you a message that tells you what is going on. What is it telling you when you highlight over it?


Did my answer(s) help you? Give it a kudos by clicking the Thumbs Up!
Did my post answer your question(s)? Mark my post as a solution. This will help others find the solution.

Proud to be a Super User!

swise001
Continued Contributor
Continued Contributor

@Watsky 

 

swise001_0-1600273345116.png

"detail column must be the same type as the aggregation column for sum aggregations"

 

From the view I am using - Qty has datatype "int" and Sales has datatype "decimal".

 

Not sure if this is where the issue lies, but sharing just in case.  

 

 

 

 

 

swise001
Continued Contributor
Continued Contributor

The source table data type was ultimately the source of the issue. 

 

I updated the source View to cast "Qty" in the same format as Sales.  Once updated, the aggregation table then allowed me to select Qty for that column.  

@swise001 Awesome! You just needed a nudge 😉


Did my answer(s) help you? Give it a kudos by clicking the Thumbs Up!
Did my post answer your question(s)? Mark my post as a solution. This will help others find the solution.

Proud to be a Super User!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.