--- title: The Grain Explained | #Power BI Course 23 | daily.dev description: Understanding the 'grain' of a fact table is the foundational concept in data modeling with Power BI. The grain defines what a single row in a fact table... canonical: https://daily.dev/posts/the-grain-explained-power-bi-course-23-iztoskrrs twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: The Grain Explained | #Power BI Course 23 | daily.dev og:description: Understanding the 'grain' of a fact table is the foundational concept in data modeling with Power BI. The grain defines what a single row in a fact table... og:url: https://daily.dev/posts/the-grain-explained-power-bi-course-23-iztoskrrs og:image: https://api.daily.dev/og/posts/iztOsKRRs.png og:image:alt: The Grain Explained | #Power BI Course 23 og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # The Grain Explained | #Power BI Course 23 **[Data with Baraa](https://daily.dev/sources/datawithbaraa)** · 7 min read · 1 upvotes · 1 comments ## Summary Understanding the 'grain' of a fact table is the foundational concept in data modeling with Power BI. The grain defines what a single row in a fact table represents — it could be a line item in an order, a whole order, or a monthly aggregate. Three example fact tables illustrate how the same business data can be stored at different levels of detail. Misunderstanding the grain leads to incorrect DAX calculations, such as counting order IDs without using DISTINCTCOUNT, or summing shipping costs that repeat per line item rather than per order. Some columns within the same table can also have different grains, requiring careful attention to how each measure is aggregated. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Similar posts on daily.dev - [Best Practices for Data Warehouse Dimension and Fact Tables](https://daily.dev/posts/best-practices-for-data-warehouse-dimension-and-fact-tables-llewunn7t) · Decube · 0 upvotes · 0 comments - [Master Fact and Dimension Table Design: Best Practices for Data Engineers](https://daily.dev/posts/master-fact-and-dimension-table-design-best-practices-for-data-engineers-rmcyeffkq) · Decube · 0 upvotes · 0 comments --- Tags: [#data-warehouse](https://daily.dev/tags/data-warehouse), [#power-bi](https://daily.dev/tags/power-bi) [View this post on daily.dev](https://daily.dev/posts/the-grain-explained-power-bi-course-23-iztoskrrs) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"The Grain Explained | #Power BI Course 23","url":"https://daily.dev/posts/the-grain-explained-power-bi-course-23-iztoskrrs","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/the-grain-explained-power-bi-course-23-iztoskrrs"},"datePublished":"2026-06-16T12:53:45.083Z","dateModified":"2026-06-16T12:54:02.170Z","description":"Understanding the 'grain' of a fact table is the foundational concept in data modeling with Power BI. The grain defines what a single row in a fact table...","image":"https://i.ytimg.com/vi/FvFvjUqu8Gs/sddefault.jpg","thumbnailUrl":"https://i.ytimg.com/vi/FvFvjUqu8Gs/sddefault.jpg","isAccessibleForFree":true,"articleSection":"Data with Baraa","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"Data with Baraa","logo":"https://media.daily.dev/image/upload/s--LsPWvHOS--/f_auto,q_auto/v1780213377/logos/datawithbaraa?_a=BAMAMiWQ0","url":"https://daily.dev/sources/datawithbaraa"},"commentCount":1,"discussionUrl":"https://daily.dev/posts/the-grain-explained-power-bi-course-23-iztoskrrs","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":1},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":1}],"keywords":"data-warehouse,power-bi","timeRequired":"PT7M","video":{"@type":"VideoObject","name":"The Grain Explained | #Power BI Course 23","description":"Understanding the 'grain' of a fact table is the foundational concept in data modeling with Power BI. The grain defines what a single row in a fact table...","thumbnailUrl":"https://i.ytimg.com/vi/FvFvjUqu8Gs/sddefault.jpg","uploadDate":"2026-06-16T12:53:45.083Z","duration":"PT7M","url":"https://api.daily.dev/r/iztOsKRRs","embedUrl":"https://www.youtube.com/embed/FvFvjUqu8Gs"}} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Data with Baraa","item":"https://daily.dev/sources/datawithbaraa"},{"@type":"ListItem","position":3,"name":"The Grain Explained | #Power BI Course 23"}]} ```