Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Frequent Visitor

Summarize or Summarize Column not results same Data comparing to default aggregation on that column

 Hi Community Legends,


I've just start learning DAX and tried Summarize on Page4

but not getting same result if try to use default sum aggreagte on that column.


So used below query to create new table , but if choose Name and Unit Cost in a Visualization Type Table results are not same.

"SumOfSales", SUM ( Sales[Unit Cost] )
Really appreciate if some one can help how VertiPaQ is dealing same stuff differentially.
Many Thanks,

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors