Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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)
Once in the model - I'm trying to set the appropriate aggregations
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.
Any ideas why the Qty column column would be 'greyed' out for the SumQty detail column?
Solved! Go to Solution.
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 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?
Proud to be a Super User!
"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.
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 😉
Proud to be a Super User!
User | Count |
---|---|
122 | |
109 | |
96 | |
59 | |
57 |
User | Count |
---|---|
143 | |
119 | |
102 | |
71 | |
61 |