{"id":10572,"date":"2026-10-03T07:28:02","date_gmt":"2026-10-03T07:28:02","guid":{"rendered":"https:\/\/www.prepaway.com\/certification\/?p=10572"},"modified":"2026-11-04T12:41:28","modified_gmt":"2026-11-04T12:41:28","slug":"power-bi-relationships-cardinality-and-dax-errors","status":"publish","type":"post","link":"https:\/\/www.prepaway.com\/certification\/power-bi-relationships-cardinality-and-dax-errors\/","title":{"rendered":"Microsoft PL-300: Power BI Relationships, Cardinality, and DAX Errors"},"content":{"rendered":"<p class=\"article-deck\" style=\"order:3;max-width:860px\">When a Power BI measure returns a number that looks obviously wrong, DAX is often blamed first. Yet many \u201cDAX problems\u201d are model problems: a relationship has the wrong cardinality, a dimension key is not unique, filters are propagating in an unexpected direction, a relationship is inactive, or two tables are connected at incompatible grains.<\/p>\r\n<nav aria-label=\"Breadcrumb\" class=\"article-breadcrumbs\" style=\"order:0\"><a href=\"\/certification\/\">Home<\/a><span>\/<\/span><a href=\"\/certification\/category\/certifications\/microsoft\/\">Microsoft<\/a><span>\/<\/span><span>Microsoft PL-300: Power BI Relationships, Cardinality, and DAX Errors<\/span><\/nav><div class=\"article-kicker-row\" style=\"order:2;max-width:860px\"><a class=\"article-kicker\" href=\"\/certification\/category\/certifications\/microsoft\/\">Microsoft<\/a><span class=\"article-meta\">Published October 3, 2026<\/span><\/div><div class=\"editorial-article-shell pa-normalized-post\" style=\"order:4\"><div class=\"editorial-article-main\"><details class=\"article-toc\" open><summary>On this page<\/summary><ol><li><a href=\"#cardinality-describes-the-uniqueness-on-each-side\">Cardinality describes the uniqueness on each side<\/a><\/li><li><a href=\"#grain-must-be-clear-before-relationships-are-created\">Grain must be clear before relationships are created<\/a><\/li><li><a href=\"#single-direction-filters-are-easier-to-reason-about\">Single-direction filters are easier to reason about<\/a><\/li><li><a href=\"#many-to-many-is-a-design-signal-not-a-shortcut\">Many-to-many is a design signal, not a shortcut<\/a><\/li><li><a href=\"#inactive-relationships-are-often-correct\">Inactive relationships are often correct<\/a><\/li><li><a href=\"#bad-keys-can-masquerade-as-dax-errors\">Bad keys can masquerade as DAX errors<\/a><\/li><li><a href=\"#ambiguous-filter-paths-can-produce-surprising-results\">Ambiguous filter paths can produce surprising results<\/a><\/li><li><a href=\"#profile-data-before-changing-relationship-settings\">Profile data before changing relationship settings<\/a><\/li><li><a href=\"#debug-the-model-in-a-deliberate-sequence\">Debug the model in a deliberate sequence<\/a><\/li><\/ol><\/details><article class=\"corrected-editorial-body\"><p>Those issues matter directly to <a href=\"https:\/\/www.prepaway.com\/pl-300-exam.html\">Microsoft PL-300<\/a>, where candidates are expected to configure relationships and model data appropriately. A <a href=\"https:\/\/www.prepaway.com\/microsoft-certified-power-bi-data-analyst-associate-certification-exams.html\">Microsoft Power BI Data Analyst Associate<\/a> should be able to read a model diagram as a set of filter paths, not just a collection of tables joined by lines.<\/p>\r\n<p>The fastest way to debug many strange totals is to stop editing the measure and ask whether the model is allowing the right rows to become visible in the first place.<\/p>\r\n<h3 id=\"cardinality-describes-the-uniqueness-on-each-side\">Cardinality describes the uniqueness on each side<\/h3>\r\n<p>A classic dimensional model uses one-to-many relationships. A dimension table contains one row per business key, while a fact table contains many transactions that reference that key. The \u201cone\u201d side must therefore contain unique values for the relationship to behave as intended.<\/p>\r\n<p>If the supposed dimension contains duplicate keys, Power BI may reject the one-to-many relationship or force the modeler toward a many-to-many design. That should trigger investigation rather than an automatic switch. Duplicates can mean the dimension is at the wrong grain, history has been mixed into a current-state table, or the source contains a data-quality defect.<\/p>\r\n<p>The structure is central to <a href=\"https:\/\/www.prepaway.com\/certification\/the-ultimate-guide-to-data-modeling-concepts-techniques-and-uses\/\">data modeling<\/a>: relationships work correctly only when table grain and key uniqueness are explicit.<\/p>\r\n<h3 id=\"grain-must-be-clear-before-relationships-are-created\">Grain must be clear before relationships are created<\/h3>\r\n<p>Every fact table should have a definable grain such as one row per order line, one row per daily account balance, or one row per support case event. Every dimension should likewise state what one row represents.<\/p>\r\n<p>Problems appear when a relationship is created between fields that look similar but represent different grains. A monthly target table connected directly to a transaction-level sales table by date can duplicate target values across every transaction. A customer table containing multiple rows per customer because of history cannot act as a simple one-row dimension without additional design.<\/p>\r\n<p>State the grain in plain language before opening the relationship dialog. If two tables cannot be described consistently, the relationship probably needs a bridge, a separate dimension, or a transformation upstream.<\/p>\r\n<h3 id=\"single-direction-filters-are-easier-to-reason-about\">Single-direction filters are easier to reason about<\/h3>\r\n<p>In a conventional star schema, filters normally move from dimensions on the one side into facts on the many side. This makes queries predictable: selecting a product filters sales, but sales rows do not automatically redefine which products exist in the dimension.<\/p>\r\n<p>Bidirectional filtering can be useful in specific designs, but it expands the number of filter paths. In larger models it can create ambiguity, unexpected blank values, or surprising interactions between facts that share dimensions.<\/p>\r\n<p>The comparison between <a href=\"https:\/\/www.prepaway.com\/certification\/a-comparison-between-star-schema-and-snowflake-schema\/\">star and snowflake schemas<\/a> is relevant because model shape affects filter behavior. The best relationship setting is the one that expresses the analytical path clearly, not the one that makes a difficult visual work with the fewest clicks.<\/p>\r\n<h3 id=\"many-to-many-is-a-design-signal-not-a-shortcut\">Many-to-many is a design signal, not a shortcut<\/h3>\r\n<p>Many-to-many relationships are legitimate when the business relationship is genuinely many-to-many. A consultant can work on many projects and a project can have many consultants. A product can belong to multiple campaigns and a campaign can contain multiple products. Those cases usually benefit from a bridge table that makes the relationship explicit.<\/p>\r\n<p>Using many-to-many because neither side is unique can hide a more basic modeling problem. The results may look correct for some filters and fail for others, especially when totals are evaluated at a broader context.<\/p>\r\n<p>Before accepting many-to-many, identify the business entity that connects the tables and decide whether a bridge or conformed dimension would represent it more transparently.<\/p>\r\n<h3 id=\"inactive-relationships-are-often-correct\">Inactive relationships are often correct<\/h3>\r\n<p>A model can contain multiple relationships between two tables while only one is active by default. A sales fact might have Order Date, Ship Date, and Invoice Date, all related to the same Date dimension. One can be active while measures that need another date role activate the appropriate relationship inside the calculation.<\/p>\r\n<p>The presence of an inactive relationship does not mean the model is broken. It means the default filter path is intentionally different from an alternate analytical path.<\/p>\r\n<p>Problems arise when report authors forget which date relationship a measure is using. A total may be correct but attributed to the wrong period. Naming measures and date roles clearly reduces that risk.<\/p>\r\n<h3 id=\"bad-keys-can-masquerade-as-dax-errors\">Bad keys can masquerade as DAX errors<\/h3>\r\n<p>Suppose a total doubles after a new source load. Rewriting SUMX or CALCULATE may be pointless if a dimension now contains duplicate keys and causes rows to match more than once. Similarly, an unexpected blank category may indicate foreign keys in the fact table that no longer match the dimension.<\/p>\r\n<p>That is why <a href=\"https:\/\/www.prepaway.com\/certification\/exploring-the-full-spectrum-of-data-quality\/\">data quality<\/a> belongs in model troubleshooting. Referential integrity, uniqueness, valid domains, and stable data types are structural requirements for reliable analytics.<\/p>\r\n<p>A useful diagnostic is to profile the relationship columns directly. Count distinct keys, search for nulls, compare unmatched values, and verify whether the source changed its grain. Evidence about keys often resolves the issue faster than experimenting with DAX syntax.<\/p>\r\n<h3 id=\"ambiguous-filter-paths-can-produce-surprising-results\">Ambiguous filter paths can produce surprising results<\/h3>\r\n<p>When multiple active paths connect the same tables, the engine must determine how filters should propagate. Complex bidirectional relationships can create ambiguous routes that are hard for modelers and users to reason about.<\/p>\r\n<p>Draw the path that a filter takes from a slicer to the measure\u2019s fact table. If there are several routes, ask whether they are all required. Often the model can be simplified by returning to shared dimensions that filter facts in a controlled direction.<\/p>\r\n<p>This is also a maintainability issue. A model that only one expert can mentally simulate becomes fragile when new tables or security rules are added.<\/p>\r\n<h3 id=\"profile-data-before-changing-relationship-settings\">Profile data before changing relationship settings<\/h3>\r\n<p>Autodetection can create useful relationships, but it cannot understand business meaning. Two columns with matching names may not be equivalent keys, and two fields with different names may represent the same entity.<\/p>\r\n<p>Use <a href=\"https:\/\/www.prepaway.com\/certification\/mastering-data-profiling-in-etl-definition-procedure-tools-practices\/\">data profiling<\/a> to inspect distinct counts, null percentages, minimum and maximum values, and frequency distributions before deciding cardinality. A column that was unique in a sample may become duplicated when the full history is loaded.<\/p>\r\n<p>Profiling also helps reveal slowly changing dimensions, late-arriving facts, and reused identifiers. Those conditions require modeling decisions that a simple one-to-many relationship cannot solve by itself.<\/p>\r\n<p>Use simple count measures as relationship probes. A distinct count of dimension keys, a raw row count of the fact, and a count of unmatched foreign keys can reveal whether filters are reaching the intended table. Put those diagnostics beside the business measure while testing. If the base counts change unexpectedly when a slicer is applied, the model path deserves attention before the business formula does.<\/p>\r\n<p>Also distinguish relationship problems from aggregation-grain problems. A monthly budget can be modeled correctly yet still look repeated when displayed beside daily sales if the visual mixes grains carelessly. In that case the relationship may be valid; the analytical question needs a measure that respects how the budget should allocate or repeat. Correct modeling does not remove the need to reason about grain at query time.<\/p>\r\n<p>Security can expose relationship flaws that ordinary testing misses. Row-level security filters propagate through the same relationship graph that report filters use. A model that appears correct for an unrestricted administrator can behave differently for a secured user if bidirectional paths, bridge tables, or inactive relationships are involved. Test representative roles and confirm both the visible totals and the rows that should be inaccessible. Relationship design is part of security correctness, not only analytical correctness.<\/p>\r\n<p>When two fact tables need to be compared, resist the urge to relate them directly unless the business relationship truly supports it. Sales and budget, for example, usually compare more cleanly through shared Date, Product, or Department dimensions. Fact-to-fact shortcuts can create duplicated paths and make filter behavior depend on the current visual. Shared dimensions preserve a clearer analytical contract as additional facts are added later.<\/p>\r\n<p>Keep relationship names and model layouts readable for the next analyst. Organize tables so dimensions and facts are visually distinguishable, hide technical keys from report authors when they are not meant for use, and document unusual bridge or inactive-relationship patterns. A transparent model prevents future developers from \u201cfixing\u201d an intentional design by adding another path that creates ambiguity.<\/p>\r\n<h3 id=\"debug-the-model-in-a-deliberate-sequence\">Debug the model in a deliberate sequence<\/h3>\r\n<p>When a measure looks wrong, start with a simple visual containing keys and base values rather than the final report page. Verify the grain of each table. Confirm that the one side is unique. Check active relationships and filter direction. Test unmatched keys. Then evaluate the measure in progressively more complex contexts.<\/p>\r\n<p>This sequence separates structural errors from calculation errors. If the base rows are already duplicated or filtered incorrectly, no measure rewrite can make the model trustworthy.<\/p>\r\n<p>Power BI becomes easier to debug when relationships are treated as logic rather than plumbing. Cardinality, direction, grain, and key quality determine which rows are visible to DAX. Fix that foundation first, and many apparent formula problems disappear without changing the formula at all.<\/p><\/article><\/div><aside aria-label=\"Browse topics\" class=\"topic-nav-panel article-topic-nav pa-unified-topic-nav\"><h2 class=\"topic-nav-title\">Browse Topics<\/h2><details class=\"topic-group\" open>\n\n<summary><span>Certifications<small>Vendor and credential guides<\/small><\/span><\/summary><div class=\"topic-group-body\"><a class=\"topic-view-all\" href=\"\/certification\/category\/certifications\/\">View all Certifications \u2192<\/a><a href=\"\/certification\/category\/certifications\/microsoft\/\">Microsoft<\/a><a href=\"\/certification\/category\/certifications\/amazon\/\">Amazon<\/a><a href=\"\/certification\/category\/certifications\/comptia\/\">CompTIA<\/a><a href=\"\/certification\/category\/certifications\/cisco\/\">Cisco<\/a><a href=\"\/certification\/category\/certifications\/project-management\/\">Project Management<\/a><a href=\"\/certification\/category\/certifications\/google\/\">Google<\/a><a href=\"\/certification\/category\/certifications\/isc2\/\">ISC2<\/a><a href=\"\/certification\/category\/certifications\/fortinet\/\">Fortinet<\/a><a href=\"\/certification\/category\/certifications\/isaca\/\">ISACA<\/a><a href=\"\/certification\/category\/certifications\/databricks\/\">Databricks<\/a><a href=\"\/certification\/category\/certifications\/servicenow\/\">ServiceNow<\/a><a href=\"\/certification\/category\/certifications\/anthropic\/\">Anthropic<\/a><a href=\"\/certification\/category\/certifications\/ec-council\/\">EC-Council<\/a><a href=\"\/certification\/category\/certifications\/palo-alto-networks\/\">Palo Alto Networks<\/a><a href=\"\/certification\/category\/certifications\/linux-foundation\/\">Linux Foundation<\/a><a href=\"\/certification\/category\/certifications\/vmware\/\">VMware<\/a><a href=\"\/certification\/category\/certifications\/itil\/\">ITIL<\/a><a href=\"\/certification\/category\/certifications\/hpe-aruba\/\">HPE \/ Aruba<\/a><a href=\"\/certification\/category\/certifications\/check-point\/\">Check Point<\/a><a href=\"\/certification\/category\/certifications\/hashicorp\/\">HashiCorp<\/a><a href=\"\/certification\/category\/certifications\/acams\/\">ACAMS<\/a><a href=\"\/certification\/category\/certifications\/the-open-group\/\">The Open Group<\/a><a href=\"\/certification\/category\/certifications\/iapp\/\">IAPP<\/a><a href=\"\/certification\/category\/certifications\/nvidia\/\">NVIDIA<\/a><a href=\"\/certification\/category\/certifications\/netapp\/\">NetApp<\/a><\/div>\n\n<\/details><details class=\"topic-group\" open>\n\n<summary><span>Technology<small>AI, cloud, security and data<\/small><\/span><\/summary><div class=\"topic-group-body\"><a class=\"topic-view-all\" href=\"\/certification\/category\/technology\/\">View all Technology \u2192<\/a><a href=\"\/certification\/category\/technology\/cybersecurity\/\">Cybersecurity<\/a><a href=\"\/certification\/category\/technology\/data\/\">Data &amp; Analytics<\/a><a href=\"\/certification\/category\/technology\/ai-machine-learning\/\">AI &amp; Machine Learning<\/a><a href=\"\/certification\/category\/technology\/networking\/\">Networking<\/a><a href=\"\/certification\/category\/technology\/cloud\/\">Cloud &amp; Architecture<\/a><a href=\"\/certification\/category\/technology\/it-operations-service-management\/\">IT Operations &amp; Service Management<\/a><a href=\"\/certification\/category\/technology\/programming\/\">Programming &amp; Development<\/a><a href=\"\/certification\/category\/technology\/systems-infrastructure\/\">Systems &amp; Infrastructure<\/a><a href=\"\/certification\/category\/technology\/devops\/\">DevOps &amp; Automation<\/a><a href=\"\/certification\/category\/technology\/enterprise-architecture\/\">Enterprise Architecture<\/a><a href=\"\/certification\/category\/technology\/software\/\">Software<\/a><\/div>\n\n<\/details><details class=\"topic-group\" open>\n\n<summary><span>College Test Prep<small>College exams and study plans<\/small><\/span><\/summary><div class=\"topic-group-body\"><a class=\"topic-view-all\" href=\"\/certification\/category\/college-test-prep\/\">View all Test Prep \u2192<\/a><a href=\"\/certification\/category\/college-test-prep\/gmat\/\">GMAT<\/a><a href=\"\/certification\/category\/college-test-prep\/mcat\/\">MCAT<\/a><a href=\"\/certification\/category\/college-test-prep\/sat\/\">SAT<\/a><a href=\"\/certification\/category\/college-test-prep\/act\/\">ACT<\/a><a href=\"\/certification\/category\/college-test-prep\/asvab\/\">ASVAB<\/a><a href=\"\/certification\/category\/college-test-prep\/psat\/\">PSAT<\/a><a href=\"\/certification\/category\/college-test-prep\/teas\/\">TEAS<\/a><a href=\"\/certification\/category\/college-test-prep\/lsat\/\">LSAT<\/a><\/div>\n\n<\/details><details class=\"topic-group\" open>\n\n<summary><span>Career<small>Roles, skills and job search<\/small><\/span><\/summary><div class=\"topic-group-body\"><a class=\"topic-view-all\" href=\"\/certification\/category\/career\/\">View all Career \u2192<\/a><a href=\"\/certification\/category\/career\/career-guides\/\">Career Guides<\/a><a href=\"\/certification\/category\/career\/salaries-roles\/\">Salaries &amp; Roles<\/a><a href=\"\/certification\/category\/career\/job-search\/\">Job Search<\/a><\/div>\n\n<\/details><details class=\"topic-group\" open>\n\n<summary><span>Governance &amp; Compliance<small>Risk, privacy and audit<\/small><\/span><\/summary><div class=\"topic-group-body\"><a class=\"topic-view-all\" href=\"\/certification\/category\/governance-compliance\/\">View all Governance &amp; Compliance \u2192<\/a><a href=\"\/certification\/category\/governance-compliance\/security-governance-audit\/\">Security Governance &amp; Audit<\/a><a href=\"\/certification\/category\/governance-compliance\/ai-governance-privacy\/\">AI Governance &amp; Privacy<\/a><a href=\"\/certification\/category\/governance-compliance\/anti-money-laundering\/\">Anti-Money Laundering<\/a><\/div>\n\n<\/details><\/aside><\/div>","protected":false},"excerpt":{"rendered":"<p>When a Power BI measure returns a number that looks obviously wrong, DAX is often blamed first. Yet many \u201cDAX problems\u201d are model problems: a relationship has the wrong cardinality, a dimension key is not unique, filters are propagating in an unexpected direction, a relationship is inactive, or two tables are connected at incompatible grains. Home\/Microsoft\/Microsoft PL-300: Power BI Relationships, Cardinality, and DAX ErrorsMicrosoftPublished October 3, 2026On this pageCardinality describes the uniqueness on each sideGrain must be clear before relationships are createdSingle-direction filters are easier to reason aboutMany-to-many is a&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2204,2182],"tags":[],"class_list":["post-10572","post","type-post","status-publish","format-standard","hentry","category-data","category-microsoft"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.2.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"When a Power BI measure returns a number that looks obviously wrong, DAX is often blamed first. Yet many \u201cDAX problems\u201d are model problems: a relationship has the wrong cardinality, a dimension key is not unique, filters are propagating in an unexpected direction, a relationship is inactive, or two tables are connected at incompatible grains.\" \/>\n\t<meta name=\"robots\" content=\"max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n\t<meta name=\"author\" content=\"admin\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/www.prepaway.com\/certification\/power-bi-relationships-cardinality-and-dax-errors\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.2.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_US\" \/>\n\t\t<meta property=\"og:site_name\" content=\"PrepAway - Fastest Way to Pass IT Certification Exams - PrepAway\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Microsoft PL-300: Power BI Relationships, Cardinality, and DAX Errors - PrepAway\" \/>\n\t\t<meta property=\"og:description\" content=\"When a Power BI measure returns a number that looks obviously wrong, DAX is often blamed first. Yet many \u201cDAX problems\u201d are model problems: a relationship has the wrong cardinality, a dimension key is not unique, filters are propagating in an unexpected direction, a relationship is inactive, or two tables are connected at incompatible grains.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/www.prepaway.com\/certification\/power-bi-relationships-cardinality-and-dax-errors\/\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/www.prepaway.com\/certification\/wp-content\/uploads\/2017\/12\/logo.png\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/www.prepaway.com\/certification\/wp-content\/uploads\/2017\/12\/logo.png\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2026-10-03T07:28:02+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2026-11-04T12:41:28+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Microsoft PL-300: Power BI Relationships, Cardinality, and DAX Errors - PrepAway\" \/>\n\t\t<meta name=\"twitter:description\" content=\"When a Power BI measure returns a number that looks obviously wrong, DAX is often blamed first. Yet many \u201cDAX problems\u201d are model problems: a relationship has the wrong cardinality, a dimension key is not unique, filters are propagating in an unexpected direction, a relationship is inactive, or two tables are connected at incompatible grains.\" \/>\n\t\t<meta name=\"twitter:image\" content=\"https:\/\/www.prepaway.com\/certification\/wp-content\/uploads\/2017\/12\/logo.png\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BlogPosting\",\"@id\":\"https:\\\/\\\/www.prepaway.com\\\/certification\\\/power-bi-relationships-cardinality-and-dax-errors\\\/#blogposting\",\"name\":\"Microsoft PL-300: Power BI Relationships, Cardinality, and DAX Errors - PrepAway\",\"headline\":\"Microsoft PL-300: Power BI Relationships, Cardinality, and DAX Errors\",\"author\":{\"@id\":\"https:\\\/\\\/www.prepaway.com\\\/certification\\\/author\\\/admin\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/www.prepaway.com\\\/certification\\\/#organization\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/www.prepaway.com\\\/certification\\\/wp-content\\\/uploads\\\/2017\\\/12\\\/logo.png\",\"@id\":\"https:\\\/\\\/www.prepaway.com\\\/certification\\\/#articleImage\",\"width\":186,\"height\":38},\"datePublished\":\"2026-10-03T07:28:02+00:00\",\"dateModified\":\"2026-11-04T12:41:28+00:00\",\"inLanguage\":\"en-US\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.prepaway.com\\\/certification\\\/power-bi-relationships-cardinality-and-dax-errors\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.prepaway.com\\\/certification\\\/power-bi-relationships-cardinality-and-dax-errors\\\/#webpage\"},\"articleSection\":\"Data &amp; Analytics, Microsoft\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.prepaway.com\\\/certification\\\/power-bi-relationships-cardinality-and-dax-errors\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.prepaway.com\\\/certification\\\/#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.prepaway.com\\\/certification\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.prepaway.com\\\/certification\\\/category\\\/certifications\\\/#listItem\",\"name\":\"Certifications\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.prepaway.com\\\/certification\\\/category\\\/certifications\\\/#listItem\",\"position\":2,\"name\":\"Certifications\",\"item\":\"https:\\\/\\\/www.prepaway.com\\\/certification\\\/category\\\/certifications\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.prepaway.com\\\/certification\\\/category\\\/certifications\\\/microsoft\\\/#listItem\",\"name\":\"Microsoft\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.prepaway.com\\\/certification\\\/#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.prepaway.com\\\/certification\\\/category\\\/certifications\\\/microsoft\\\/#listItem\",\"position\":3,\"name\":\"Microsoft\",\"item\":\"https:\\\/\\\/www.prepaway.com\\\/certification\\\/category\\\/certifications\\\/microsoft\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.prepaway.com\\\/certification\\\/power-bi-relationships-cardinality-and-dax-errors\\\/#listItem\",\"name\":\"Microsoft PL-300: Power BI Relationships, Cardinality, and DAX Errors\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.prepaway.com\\\/certification\\\/category\\\/certifications\\\/#listItem\",\"name\":\"Certifications\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.prepaway.com\\\/certification\\\/power-bi-relationships-cardinality-and-dax-errors\\\/#listItem\",\"position\":4,\"name\":\"Microsoft PL-300: Power BI Relationships, Cardinality, and DAX Errors\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.prepaway.com\\\/certification\\\/category\\\/certifications\\\/microsoft\\\/#listItem\",\"name\":\"Microsoft\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.prepaway.com\\\/certification\\\/#organization\",\"name\":\"PrepAway Certification\",\"description\":\"Fastest Way to Pass IT Certification Exams - PrepAway\",\"url\":\"https:\\\/\\\/www.prepaway.com\\\/certification\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/www.prepaway.com\\\/certification\\\/wp-content\\\/uploads\\\/2017\\\/12\\\/logo.png\",\"@id\":\"https:\\\/\\\/www.prepaway.com\\\/certification\\\/power-bi-relationships-cardinality-and-dax-errors\\\/#organizationLogo\",\"width\":186,\"height\":38},\"image\":{\"@id\":\"https:\\\/\\\/www.prepaway.com\\\/certification\\\/power-bi-relationships-cardinality-and-dax-errors\\\/#organizationLogo\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.prepaway.com\\\/certification\\\/author\\\/admin\\\/#author\",\"url\":\"https:\\\/\\\/www.prepaway.com\\\/certification\\\/author\\\/admin\\\/\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/www.prepaway.com\\\/certification\\\/power-bi-relationships-cardinality-and-dax-errors\\\/#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/69b3eaeff2d2bf70759f8c56ad9a52614771e4f88b2806c16f0a25cc297f9267?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"admin\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.prepaway.com\\\/certification\\\/power-bi-relationships-cardinality-and-dax-errors\\\/#webpage\",\"url\":\"https:\\\/\\\/www.prepaway.com\\\/certification\\\/power-bi-relationships-cardinality-and-dax-errors\\\/\",\"name\":\"Microsoft PL-300: Power BI Relationships, Cardinality, and DAX Errors - PrepAway\",\"description\":\"When a Power BI measure returns a number that looks obviously wrong, DAX is often blamed first. Yet many \\u201cDAX problems\\u201d are model problems: a relationship has the wrong cardinality, a dimension key is not unique, filters are propagating in an unexpected direction, a relationship is inactive, or two tables are connected at incompatible grains.\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.prepaway.com\\\/certification\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.prepaway.com\\\/certification\\\/power-bi-relationships-cardinality-and-dax-errors\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/www.prepaway.com\\\/certification\\\/author\\\/admin\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/www.prepaway.com\\\/certification\\\/author\\\/admin\\\/#author\"},\"datePublished\":\"2026-10-03T07:28:02+00:00\",\"dateModified\":\"2026-11-04T12:41:28+00:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.prepaway.com\\\/certification\\\/#website\",\"url\":\"https:\\\/\\\/www.prepaway.com\\\/certification\\\/\",\"name\":\"PrepAway Certification\",\"description\":\"Fastest Way to Pass IT Certification Exams - PrepAway\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.prepaway.com\\\/certification\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Microsoft PL-300: Power BI Relationships, Cardinality, and DAX Errors - PrepAway","description":"When a Power BI measure returns a number that looks obviously wrong, DAX is often blamed first. Yet many \u201cDAX problems\u201d are model problems: a relationship has the wrong cardinality, a dimension key is not unique, filters are propagating in an unexpected direction, a relationship is inactive, or two tables are connected at incompatible grains.","canonical_url":"https:\/\/www.prepaway.com\/certification\/power-bi-relationships-cardinality-and-dax-errors\/","robots":"max-snippet:-1, max-image-preview:large, max-video-preview:-1","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"https:\/\/www.prepaway.com\/certification\/power-bi-relationships-cardinality-and-dax-errors\/#blogposting","name":"Microsoft PL-300: Power BI Relationships, Cardinality, and DAX Errors - PrepAway","headline":"Microsoft PL-300: Power BI Relationships, Cardinality, and DAX Errors","author":{"@id":"https:\/\/www.prepaway.com\/certification\/author\/admin\/#author"},"publisher":{"@id":"https:\/\/www.prepaway.com\/certification\/#organization"},"image":{"@type":"ImageObject","url":"https:\/\/www.prepaway.com\/certification\/wp-content\/uploads\/2017\/12\/logo.png","@id":"https:\/\/www.prepaway.com\/certification\/#articleImage","width":186,"height":38},"datePublished":"2026-10-03T07:28:02+00:00","dateModified":"2026-11-04T12:41:28+00:00","inLanguage":"en-US","mainEntityOfPage":{"@id":"https:\/\/www.prepaway.com\/certification\/power-bi-relationships-cardinality-and-dax-errors\/#webpage"},"isPartOf":{"@id":"https:\/\/www.prepaway.com\/certification\/power-bi-relationships-cardinality-and-dax-errors\/#webpage"},"articleSection":"Data &amp; Analytics, Microsoft"},{"@type":"BreadcrumbList","@id":"https:\/\/www.prepaway.com\/certification\/power-bi-relationships-cardinality-and-dax-errors\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/www.prepaway.com\/certification\/#listItem","position":1,"name":"Home","item":"https:\/\/www.prepaway.com\/certification\/","nextItem":{"@type":"ListItem","@id":"https:\/\/www.prepaway.com\/certification\/category\/certifications\/#listItem","name":"Certifications"}},{"@type":"ListItem","@id":"https:\/\/www.prepaway.com\/certification\/category\/certifications\/#listItem","position":2,"name":"Certifications","item":"https:\/\/www.prepaway.com\/certification\/category\/certifications\/","nextItem":{"@type":"ListItem","@id":"https:\/\/www.prepaway.com\/certification\/category\/certifications\/microsoft\/#listItem","name":"Microsoft"},"previousItem":{"@type":"ListItem","@id":"https:\/\/www.prepaway.com\/certification\/#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/www.prepaway.com\/certification\/category\/certifications\/microsoft\/#listItem","position":3,"name":"Microsoft","item":"https:\/\/www.prepaway.com\/certification\/category\/certifications\/microsoft\/","nextItem":{"@type":"ListItem","@id":"https:\/\/www.prepaway.com\/certification\/power-bi-relationships-cardinality-and-dax-errors\/#listItem","name":"Microsoft PL-300: Power BI Relationships, Cardinality, and DAX Errors"},"previousItem":{"@type":"ListItem","@id":"https:\/\/www.prepaway.com\/certification\/category\/certifications\/#listItem","name":"Certifications"}},{"@type":"ListItem","@id":"https:\/\/www.prepaway.com\/certification\/power-bi-relationships-cardinality-and-dax-errors\/#listItem","position":4,"name":"Microsoft PL-300: Power BI Relationships, Cardinality, and DAX Errors","previousItem":{"@type":"ListItem","@id":"https:\/\/www.prepaway.com\/certification\/category\/certifications\/microsoft\/#listItem","name":"Microsoft"}}]},{"@type":"Organization","@id":"https:\/\/www.prepaway.com\/certification\/#organization","name":"PrepAway Certification","description":"Fastest Way to Pass IT Certification Exams - PrepAway","url":"https:\/\/www.prepaway.com\/certification\/","logo":{"@type":"ImageObject","url":"https:\/\/www.prepaway.com\/certification\/wp-content\/uploads\/2017\/12\/logo.png","@id":"https:\/\/www.prepaway.com\/certification\/power-bi-relationships-cardinality-and-dax-errors\/#organizationLogo","width":186,"height":38},"image":{"@id":"https:\/\/www.prepaway.com\/certification\/power-bi-relationships-cardinality-and-dax-errors\/#organizationLogo"}},{"@type":"Person","@id":"https:\/\/www.prepaway.com\/certification\/author\/admin\/#author","url":"https:\/\/www.prepaway.com\/certification\/author\/admin\/","name":"admin","image":{"@type":"ImageObject","@id":"https:\/\/www.prepaway.com\/certification\/power-bi-relationships-cardinality-and-dax-errors\/#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/69b3eaeff2d2bf70759f8c56ad9a52614771e4f88b2806c16f0a25cc297f9267?s=96&d=mm&r=g","width":96,"height":96,"caption":"admin"}},{"@type":"WebPage","@id":"https:\/\/www.prepaway.com\/certification\/power-bi-relationships-cardinality-and-dax-errors\/#webpage","url":"https:\/\/www.prepaway.com\/certification\/power-bi-relationships-cardinality-and-dax-errors\/","name":"Microsoft PL-300: Power BI Relationships, Cardinality, and DAX Errors - PrepAway","description":"When a Power BI measure returns a number that looks obviously wrong, DAX is often blamed first. Yet many \u201cDAX problems\u201d are model problems: a relationship has the wrong cardinality, a dimension key is not unique, filters are propagating in an unexpected direction, a relationship is inactive, or two tables are connected at incompatible grains.","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/www.prepaway.com\/certification\/#website"},"breadcrumb":{"@id":"https:\/\/www.prepaway.com\/certification\/power-bi-relationships-cardinality-and-dax-errors\/#breadcrumblist"},"author":{"@id":"https:\/\/www.prepaway.com\/certification\/author\/admin\/#author"},"creator":{"@id":"https:\/\/www.prepaway.com\/certification\/author\/admin\/#author"},"datePublished":"2026-10-03T07:28:02+00:00","dateModified":"2026-11-04T12:41:28+00:00"},{"@type":"WebSite","@id":"https:\/\/www.prepaway.com\/certification\/#website","url":"https:\/\/www.prepaway.com\/certification\/","name":"PrepAway Certification","description":"Fastest Way to Pass IT Certification Exams - PrepAway","inLanguage":"en-US","publisher":{"@id":"https:\/\/www.prepaway.com\/certification\/#organization"}}]},"og:locale":"en_US","og:site_name":"PrepAway - Fastest Way to Pass IT Certification Exams - PrepAway","og:type":"article","og:title":"Microsoft PL-300: Power BI Relationships, Cardinality, and DAX Errors - PrepAway","og:description":"When a Power BI measure returns a number that looks obviously wrong, DAX is often blamed first. Yet many \u201cDAX problems\u201d are model problems: a relationship has the wrong cardinality, a dimension key is not unique, filters are propagating in an unexpected direction, a relationship is inactive, or two tables are connected at incompatible grains.","og:url":"https:\/\/www.prepaway.com\/certification\/power-bi-relationships-cardinality-and-dax-errors\/","og:image":"https:\/\/www.prepaway.com\/certification\/wp-content\/uploads\/2017\/12\/logo.png","og:image:secure_url":"https:\/\/www.prepaway.com\/certification\/wp-content\/uploads\/2017\/12\/logo.png","article:published_time":"2026-10-03T07:28:02+00:00","article:modified_time":"2026-11-04T12:41:28+00:00","twitter:card":"summary_large_image","twitter:title":"Microsoft PL-300: Power BI Relationships, Cardinality, and DAX Errors - PrepAway","twitter:description":"When a Power BI measure returns a number that looks obviously wrong, DAX is often blamed first. Yet many \u201cDAX problems\u201d are model problems: a relationship has the wrong cardinality, a dimension key is not unique, filters are propagating in an unexpected direction, a relationship is inactive, or two tables are connected at incompatible grains.","twitter:image":"https:\/\/www.prepaway.com\/certification\/wp-content\/uploads\/2017\/12\/logo.png"},"aioseo_meta_data":{"post_id":"10572","title":null,"description":null,"keywords":[],"keyphrases":{"focus":{"keyphrase":"","score":0,"analysis":{"keyphraseInTitle":{"score":0,"maxScore":9,"error":1}}},"additional":[]},"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":"","og_custom_url":null,"og_article_section":null,"og_article_tags":[],"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"BlogPosting","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":"-1","robots_max_videopreview":"-1","robots_max_imagepreview":"large","priority":null,"frequency":"default","local_seo":null,"limit_modified_date":false,"created":"2026-10-03 07:28:03","updated":"2026-11-04 16:55:53","focus_keyword":null,"additional_keywords":null,"truseo_locale":null,"primary_term":null,"ai":null,"breadcrumb_settings":null,"seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/www.prepaway.com\/certification\/\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">\u00bb<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/www.prepaway.com\/certification\/category\/certifications\/\" title=\"Certifications\">Certifications<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">\u00bb<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/www.prepaway.com\/certification\/category\/certifications\/microsoft\/\" title=\"Microsoft\">Microsoft<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">\u00bb<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tMicrosoft PL-300: Power BI Relationships, Cardinality, and DAX Errors\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/www.prepaway.com\/certification\/"},{"label":"Certifications","link":"https:\/\/www.prepaway.com\/certification\/category\/certifications\/"},{"label":"Microsoft","link":"https:\/\/www.prepaway.com\/certification\/category\/certifications\/microsoft\/"},{"label":"Microsoft PL-300: Power BI Relationships, Cardinality, and DAX Errors","link":"https:\/\/www.prepaway.com\/certification\/power-bi-relationships-cardinality-and-dax-errors\/"}],"_links":{"self":[{"href":"https:\/\/www.prepaway.com\/certification\/wp-json\/wp\/v2\/posts\/10572","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.prepaway.com\/certification\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.prepaway.com\/certification\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.prepaway.com\/certification\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.prepaway.com\/certification\/wp-json\/wp\/v2\/comments?post=10572"}],"version-history":[{"count":4,"href":"https:\/\/www.prepaway.com\/certification\/wp-json\/wp\/v2\/posts\/10572\/revisions"}],"predecessor-version":[{"id":21046,"href":"https:\/\/www.prepaway.com\/certification\/wp-json\/wp\/v2\/posts\/10572\/revisions\/21046"}],"wp:attachment":[{"href":"https:\/\/www.prepaway.com\/certification\/wp-json\/wp\/v2\/media?parent=10572"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.prepaway.com\/certification\/wp-json\/wp\/v2\/categories?post=10572"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.prepaway.com\/certification\/wp-json\/wp\/v2\/tags?post=10572"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}