{"id":10816,"date":"2021-10-05T20:49:58","date_gmt":"2021-10-05T20:49:58","guid":{"rendered":"https:\/\/minova.nl\/?p=10816"},"modified":"2023-05-05T11:42:05","modified_gmt":"2023-05-05T11:42:05","slug":"dax-difference-between-filter-and-calculatetable","status":"publish","type":"post","link":"https:\/\/minova.nl\/en\/dax-verschil-tussen-filter-en-calculatetable\/","title":{"rendered":"DAX: Difference between FILTER and CALCULATETABLE"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"10816\" class=\"elementor elementor-10816\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-b7c59bb elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b7c59bb\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-e47234d\" data-id=\"e47234d\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-920da98 elementor-widget elementor-widget-text-editor\" data-id=\"920da98\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p class=\"MsoNormal\">In de wereld van DAX formules, zijn de twee formules die het meest door elkaar gehaald worden FILTER en CALCULATETABLE. Dat is te wijten aan het feit dat zij in bepaalde scenario&#8217;s eigenlijk hetzelfde resultaat opleveren. Bijvoorbeeld, wanneer een Matrix op het canvas wordt aangemaakt waarin een filter wordt toegepast op \u00e9\u00e9n dimensie tabel (in dit geval door het toe te voegen aan de rijen van deze Matrix) en de filter in de DAX formule wordt toegepast op een andere dimensie tabel.<\/p>\n<p class=\"MsoNormal\">Beschouw deze twee formules:<\/p>\n<p class=\"MsoNormal\"><span lang=\"EN-US\">\u00a0<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin-bottom: 0cm; line-height: 13.5pt; background: #FFFFFE;\"><span lang=\"EN-US\" style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-ansi-language: EN-US; mso-fareast-language: #1000;\">1.1 <\/span><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\">Count Sales Product A <b>FILTER<\/b> = <\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin-bottom: 0cm; line-height: 13.5pt; background: #FFFFFE;\"><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: #4472c4; mso-themecolor: accent1; mso-fareast-language: #1000;\">COUNTROWS<\/span><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\"> (<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin-bottom: 0cm; line-height: 13.5pt; background: #FFFFFE;\"><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\">\u00a0\u00a0\u00a0 <\/span><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: #4472c4; mso-themecolor: accent1; mso-fareast-language: #1000;\">FILTER<\/span><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\"> (<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin-bottom: 0cm; line-height: 13.5pt; background: #FFFFFE;\"><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 fact_Sales,<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin-bottom: 0cm; line-height: 13.5pt; background: #FFFFFE;\"><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 RELATED ( dim_Products[Productkey] ) = <\/span><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: #c00000; mso-fareast-language: #1000;\">&#8220;Product A&#8221;<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin-bottom: 0cm; line-height: 13.5pt; background: #FFFFFE;\"><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\">\u00a0\u00a0\u00a0 )<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin-bottom: 0cm; line-height: 13.5pt; background: #FFFFFE;\"><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\">)<\/span><\/p>\n<p class=\"MsoNormal\"><span lang=\"EN-US\">\u00a0<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin-bottom: 0cm; line-height: 13.5pt; background: #FFFFFE;\"><span lang=\"EN-US\" style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-ansi-language: EN-US; mso-fareast-language: #1000;\">1.2 <\/span><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\">Count Sales Product A <b>CALCULATETABLE<\/b> = <\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin-bottom: 0cm; line-height: 13.5pt; background: #FFFFFE;\"><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: #4472c4; mso-themecolor: accent1; mso-fareast-language: #1000;\">COUNTROWS<\/span><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\"> (<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin-bottom: 0cm; line-height: 13.5pt; background: #FFFFFE;\"><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\">\u00a0\u00a0\u00a0 <\/span><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: #4472c4; mso-themecolor: accent1; mso-fareast-language: #1000;\">CALCULATETABLE<\/span><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\"> (<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin-bottom: 0cm; line-height: 13.5pt; background: #FFFFFE;\"><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 fact_Sales,<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin-bottom: 0cm; line-height: 13.5pt; background: #FFFFFE;\"><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 dim_Products[Productkey] = <\/span><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: #c00000; mso-fareast-language: #1000;\">&#8220;Product A&#8221;<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin-bottom: 0cm; line-height: 13.5pt; background: #FFFFFE;\"><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\">\u00a0\u00a0\u00a0 )<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin-bottom: 0cm; line-height: 13.5pt; background: #FFFFFE;\"><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\">)<\/span><\/p>\n<p class=\"MsoNormal\"><span lang=\"EN-US\">\u00a0<\/span><\/p>\n<p class=\"MsoNormal\"><span lang=\"EN-US\">De syntaxis is eigenlijk vergelijkbaar, en dat geldt ook voor de resultaten wanneer die in deze Matrix worden toegepast:<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5106b4b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5106b4b\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-6911b14\" data-id=\"6911b14\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-44735ef elementor-widget elementor-widget-image\" data-id=\"44735ef\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" src=\"data:image\/gif;base64,R0lGODlhAQABAIAAAAAAAP\/\/\/yH5BAEAAAAALAAAAAABAAEAAAIBRAA7\" data-src=\"https:\/\/minova.nl\/wp-content\/uploads\/2021\/10\/Picture1.png\" data-srcset=\"https:\/\/minova.nl\/wp-content\/uploads\/2021\/10\/Picture1.png 560w, https:\/\/minova.nl\/wp-content\/uploads\/2021\/10\/Picture1-300x100.png 300w\" width=\"560\" height=\"186\" class=\"attachment-large size-large wp-image-10818 lazyload\" alt=\"\" sizes=\"(max-width: 560px) 100vw, 560px\"><noscript><img decoding=\"async\" width=\"560\" height=\"186\" src=\"https:\/\/minova.nl\/wp-content\/uploads\/2021\/10\/Picture1.png\" class=\"attachment-large size-large wp-image-10818\" alt=\"\" srcset=\"https:\/\/minova.nl\/wp-content\/uploads\/2021\/10\/Picture1.png 560w, https:\/\/minova.nl\/wp-content\/uploads\/2021\/10\/Picture1-300x100.png 300w\" sizes=\"(max-width: 560px) 100vw, 560px\"><\/noscript>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-559d1b0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"559d1b0\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-9eed3d1\" data-id=\"9eed3d1\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-52df913 elementor-widget elementor-widget-text-editor\" data-id=\"52df913\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>De engine heeft deze twee formules echter op een andere manier ge\u00ebvalueerd. 1.1 wordt uitgevoerd in een geneste rijcontext (waarin wordt voorzien door de FILTER-formule) binnen een filtercontext (waarin wordt voorzien door de measure).\u00a0\u00a0<\/p><p>1.2 wordt echter uitgevoerd binnen een gewijzigde filtercontext, omdat het filter in het CALCULATETABLE-instructie wordt toegevoegd aan de initi\u00eble filtercontext die alleen wordt gevuld door de maandnaam die uit de rijkop komt. Als je niet zeker bent van rij- en filtercontext, bekijk dan zeker mijn video&#8217;s over deze concepten.<\/p><p>Laten we nu eens kijken wanneer FILTER en CALCULATETABLE beginnen af te wijken.<\/p><p>Overweeg deze formules:<\/p><p><span lang=\"EN-US\">\u00a0<\/span><\/p><p style=\"margin-bottom: 0cm; line-height: 13.5pt; background: #FFFFFE;\"><span lang=\"EN-US\" style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-ansi-language: EN-US; mso-fareast-language: #1000;\">2.1 <\/span><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\">Count Sales March <b>FILTER<\/b> = <\/span><\/p><p style=\"margin-bottom: 0cm; line-height: 13.5pt; background: #FFFFFE;\"><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: #4472c4; mso-themecolor: accent1; mso-fareast-language: #1000;\">COUNTROWS<\/span><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\"> (<\/span><\/p><p style=\"margin-bottom: 0cm; line-height: 13.5pt; background: #FFFFFE;\"><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\">\u00a0\u00a0\u00a0 <\/span><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: #4472c4; mso-themecolor: accent1; mso-fareast-language: #1000;\">FILTER<\/span><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\"> (<\/span><\/p><p style=\"margin-bottom: 0cm; line-height: 13.5pt; background: #FFFFFE;\"><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 fact_Sales,<\/span><\/p><p style=\"margin-bottom: 0cm; line-height: 13.5pt; background: #FFFFFE;\"><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: #4472c4; mso-themecolor: accent1; mso-fareast-language: #1000;\">RELATED<\/span><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\"> ( &#8216;Calendar'[Monthname] ) = <\/span><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: #c00000; mso-fareast-language: #1000;\">&#8220;March&#8221;<\/span><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\"> &amp;&amp;\u00a0 <\/span><\/p><p style=\"margin-bottom: 0cm; line-height: 13.5pt; background: #FFFFFE;\"><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: #4472c4; mso-themecolor: accent1; mso-fareast-language: #1000;\">RELATED<\/span><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\"> (&#8216;Calendar'[Month] ) = 3<\/span><\/p><p style=\"margin-bottom: 0cm; line-height: 13.5pt; background: #FFFFFE;\"><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\">\u00a0\u00a0\u00a0 )<\/span><\/p><p style=\"margin-bottom: 0cm; line-height: 13.5pt; background: #FFFFFE;\"><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\">)<\/span><\/p><p><span lang=\"EN-US\">\u00a0<\/span><\/p><p style=\"margin-bottom: 0cm; line-height: 13.5pt; background: #FFFFFE;\"><span lang=\"EN-US\" style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-ansi-language: EN-US; mso-fareast-language: #1000;\">2.2 <\/span><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\">Count Sales March <b>CALCULATETABLE<\/b> = <\/span><\/p><p style=\"margin-bottom: 0cm; line-height: 13.5pt; background: #FFFFFE;\"><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: #4472c4; mso-themecolor: accent1; mso-fareast-language: #1000;\">COUNTROWS<\/span><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\"> (<\/span><\/p><p style=\"margin-bottom: 0cm; line-height: 13.5pt; background: #FFFFFE;\"><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\">\u00a0\u00a0\u00a0 <\/span><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: #4472c4; mso-themecolor: accent1; mso-fareast-language: #1000;\">CALCULATETABLE<\/span><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\"> (<\/span><\/p><p style=\"margin-bottom: 0cm; line-height: 13.5pt; background: #FFFFFE;\"><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 fact_Sales,<\/span><\/p><p style=\"margin-bottom: 0cm; line-height: 13.5pt; background: #FFFFFE;\"><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 &#8216;Calendar'[Monthname] = <\/span><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: #c00000; mso-fareast-language: #1000;\">&#8220;March&#8221;<\/span><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-color-alt: windowtext; mso-fareast-language: #1000;\">,<\/span><\/p><p style=\"margin-bottom: 0cm; line-height: 13.5pt; background: #FFFFFE;\"><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 &#8216;Calendar'[Month] = 3<\/span><\/p><p style=\"margin-bottom: 0cm; line-height: 13.5pt; background: #FFFFFE;\"><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\">\u00a0\u00a0\u00a0 )<\/span><\/p><p style=\"margin-bottom: 0cm; line-height: 13.5pt; background: #FFFFFE;\"><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\">)<\/span><\/p><p><span lang=\"EN-US\">\u00a0<\/span><\/p><p>2.1 filtert eenvoudigweg de verkooptabel op alleen maart, dus als een filter uit de rij koptekst op een andere maand valt, wordt een filter toegepast op die andere maand en op maart, wat resulteert in een blanco resultaat.<\/p><p>2.2 daarentegen overschrijft de maandnaam die uit de rij koptekst komt in de filter context, dus het zal altijd de waarde voor maart teruggeven, ongeacht de waarde in de rij koptekst.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-4b00070 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4b00070\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-c70d35b\" data-id=\"c70d35b\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-2de4114 elementor-widget elementor-widget-image\" data-id=\"2de4114\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"data:image\/gif;base64,R0lGODlhAQABAIAAAAAAAP\/\/\/yH5BAEAAAAALAAAAAABAAEAAAIBRAA7\" data-src=\"https:\/\/minova.nl\/wp-content\/uploads\/2021\/10\/Picture2.png\" data-srcset=\"https:\/\/minova.nl\/wp-content\/uploads\/2021\/10\/Picture2.png 573w, https:\/\/minova.nl\/wp-content\/uploads\/2021\/10\/Picture2-300x112.png 300w\" width=\"573\" height=\"214\" class=\"attachment-large size-large wp-image-10819 lazyload\" alt=\"\" sizes=\"(max-width: 573px) 100vw, 573px\"><noscript><img loading=\"lazy\" decoding=\"async\" width=\"573\" height=\"214\" src=\"https:\/\/minova.nl\/wp-content\/uploads\/2021\/10\/Picture2.png\" class=\"attachment-large size-large wp-image-10819\" alt=\"\" srcset=\"https:\/\/minova.nl\/wp-content\/uploads\/2021\/10\/Picture2.png 573w, https:\/\/minova.nl\/wp-content\/uploads\/2021\/10\/Picture2-300x112.png 300w\" sizes=\"(max-width: 573px) 100vw, 573px\"><\/noscript>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-723cd23 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"723cd23\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-c4250c2\" data-id=\"c4250c2\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5880bfd elementor-widget elementor-widget-text-editor\" data-id=\"5880bfd\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p class=\"MsoNormal\"><span lang=\"EN-US\">En laten we nu eens kijken naar een meer diepgaand verschil tussen de twee. Nogmaals, bekijk deze formules:<\/span><\/p>\n<p class=\"MsoNormal\"><span lang=\"EN-US\">&nbsp;<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin-bottom: 0cm; line-height: 13.5pt; background: #FFFFFE;\"><span lang=\"EN-US\" style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-ansi-language: EN-US; mso-fareast-language: #1000;\">3.1 <\/span><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\">Count Sales Previous Month <b>FILTER<\/b> = <\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin-bottom: 0cm; line-height: 13.5pt; background: #FFFFFE;\"><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: #4472c4; mso-themecolor: accent1; mso-fareast-language: #1000;\">COUNTROWS<\/span><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\"> (<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin-bottom: 0cm; line-height: 13.5pt; background: #FFFFFE;\"><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\">&nbsp;&nbsp;&nbsp; <\/span><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: #4472c4; mso-themecolor: accent1; mso-fareast-language: #1000;\">FILTER<\/span><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\"> (<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin-bottom: 0cm; line-height: 13.5pt; background: #FFFFFE;\"><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; fact_Sales,<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin-bottom: 0cm; line-height: 13.5pt; background: #FFFFFE;\"><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <\/span><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: #4472c4; mso-themecolor: accent1; mso-fareast-language: #1000;\">PREVIOUSMONTH<\/span><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\"> ( &#8216;Calendar'[Date] )<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin-bottom: 0cm; line-height: 13.5pt; background: #FFFFFE;\"><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\">&nbsp;&nbsp;&nbsp; )<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin-bottom: 0cm; line-height: 13.5pt; background: #FFFFFE;\"><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\">)<\/span><\/p>\n<p class=\"MsoNormal\"><span lang=\"EN-US\">&nbsp;<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin-bottom: 0cm; line-height: 13.5pt; background: #FFFFFE;\"><span lang=\"EN-US\" style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-ansi-language: EN-US; mso-fareast-language: #1000;\">3.2 <\/span><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\">Count Sales Previous Month <b>CALCULATETABLE<\/b> = <\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin-bottom: 0cm; line-height: 13.5pt; background: #FFFFFE;\"><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: #4472c4; mso-themecolor: accent1; mso-fareast-language: #1000;\">COUNTROWS<\/span><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\"> (<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin-bottom: 0cm; line-height: 13.5pt; background: #FFFFFE;\"><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\">&nbsp;&nbsp;&nbsp; <\/span><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: #4472c4; mso-themecolor: accent1; mso-fareast-language: #1000;\">CALCULATETABLE<\/span><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\"> (<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin-bottom: 0cm; line-height: 13.5pt; background: #FFFFFE;\"><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; fact_Sales,<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin-bottom: 0cm; line-height: 13.5pt; background: #FFFFFE;\"><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <\/span><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: #4472c4; mso-themecolor: accent1; mso-fareast-language: #1000;\">PREVIOUSMONTH<\/span><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\"> ( &#8216;Calendar'[Date] )<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin-bottom: 0cm; line-height: 13.5pt; background: #FFFFFE;\"><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\">&nbsp;&nbsp;&nbsp; )<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin-bottom: 0cm; line-height: 13.5pt; background: #FFFFFE;\"><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\">)<\/span><\/p>\n<p class=\"MsoNormal\"><span lang=\"EN-US\">&nbsp;<\/span><\/p>\n<p><\/p>\n<p class=\"MsoNormal\">Aangezien CALCULATETABLE wordt gebruikt in 3.2, kan de initi\u00eble filtercontext worden overschreven door wat is opgegeven in het filterstatement, dus: PREVIOUSMONTH ( &#8216;Kalender'[Datum] ). In deze formule zorgt DAX ervoor dat de maandnaam in de initi\u00eble filtercontext wordt overschreven door de maand die er v\u00f3\u00f3r staat.<br><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-f5abe0d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f5abe0d\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-47eb3bd\" data-id=\"47eb3bd\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-58a207d elementor-widget elementor-widget-image\" data-id=\"58a207d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"data:image\/gif;base64,R0lGODlhAQABAIAAAAAAAP\/\/\/yH5BAEAAAAALAAAAAABAAEAAAIBRAA7\" data-src=\"https:\/\/minova.nl\/wp-content\/uploads\/2021\/10\/Picture3.png\" data-srcset=\"https:\/\/minova.nl\/wp-content\/uploads\/2021\/10\/Picture3.png 602w, https:\/\/minova.nl\/wp-content\/uploads\/2021\/10\/Picture3-300x112.png 300w\" width=\"600\" height=\"224\" class=\"attachment-large size-large wp-image-10820 lazyload\" alt=\"\" sizes=\"(max-width: 600px) 100vw, 600px\"><noscript><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"224\" src=\"https:\/\/minova.nl\/wp-content\/uploads\/2021\/10\/Picture3.png\" class=\"attachment-large size-large wp-image-10820\" alt=\"\" srcset=\"https:\/\/minova.nl\/wp-content\/uploads\/2021\/10\/Picture3.png 602w, https:\/\/minova.nl\/wp-content\/uploads\/2021\/10\/Picture3-300x112.png 300w\" sizes=\"(max-width: 600px) 100vw, 600px\"><\/noscript>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-3ba5276 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3ba5276\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-b16b575\" data-id=\"b16b575\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-d82afaa elementor-widget elementor-widget-text-editor\" data-id=\"d82afaa\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p class=\"MsoNormal\"><span lang=\"EN-US\">FILTER is unable of overwriting the initial filter context so trying that would give an error.<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-e65b1a8 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e65b1a8\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-2fe14dd\" data-id=\"2fe14dd\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-cfa1de0 elementor-widget elementor-widget-text-editor\" data-id=\"cfa1de0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p class=\"MsoNormal\"><span lang=\"EN-US\">Het laatste, maar zeker niet het minste verschil is het feit dat CALCULATETABLE, net als CALCULATE, een context-overgang veroorzaakt. Dus, als een formule initieel ge\u00ebvalueerd wordt binnen rij context, zal die rij context omgezet worden in een filter context. Om dit gedrag te laten zien, werken berekende kolommen goed omdat de evaluatie context van een berekende kolom rij context is. Beschouw deze 2 kolommen die we zullen toevoegen aan de dimensie Clients tabel:<\/span><\/p><p class=\"MsoNormal\"><span lang=\"EN-US\">\u00a0<\/span><\/p><p class=\"MsoNormal\" style=\"margin-bottom: 0cm; line-height: 13.5pt; background: #FFFFFE;\"><span lang=\"EN-US\" style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-ansi-language: EN-US; mso-fareast-language: #1000;\">4.1 Column <\/span><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\">Count Sales Product A FILTER = <\/span><\/p><p class=\"MsoNormal\" style=\"margin-bottom: 0cm; line-height: 13.5pt; background: #FFFFFE;\"><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: #4472c4; mso-themecolor: accent1;\">COUNTROWS<\/span><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\"> (<\/span><\/p><p class=\"MsoNormal\" style=\"margin-bottom: 0cm; line-height: 13.5pt; background: #FFFFFE;\"><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\">\u00a0\u00a0\u00a0 <\/span><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: #4472c4; mso-themecolor: accent1;\">FILTER<\/span><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\"> (<\/span><\/p><p class=\"MsoNormal\" style=\"margin-bottom: 0cm; line-height: 13.5pt; background: #FFFFFE;\"><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 fact_Sales,<\/span><\/p><p class=\"MsoNormal\" style=\"margin-bottom: 0cm; line-height: 13.5pt; background: #FFFFFE;\"><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: #4472c4; mso-themecolor: accent1;\">RELATED<\/span><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\"> ( dim_Products[Productkey] ) = <\/span><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: #c00000;\">&#8220;Product A&#8221;<\/span><\/p><p class=\"MsoNormal\" style=\"margin-bottom: 0cm; line-height: 13.5pt; background: #FFFFFE;\"><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\">\u00a0\u00a0\u00a0 )<\/span><\/p><p class=\"MsoNormal\" style=\"margin-bottom: 0cm; line-height: 13.5pt; background: #FFFFFE;\"><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\">)<\/span><\/p><p class=\"MsoNormal\"><span lang=\"EN-US\">\u00a0<\/span><\/p><p class=\"MsoNormal\" style=\"margin-bottom: 0cm; line-height: 13.5pt; background: #FFFFFE;\"><span lang=\"EN-US\" style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-ansi-language: EN-US; mso-fareast-language: #1000;\">4.2 Column <\/span><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\">Count Sales Product A <\/span><span lang=\"EN-US\" style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-ansi-language: EN-US; mso-fareast-language: #1000;\">CALCULATETABLE<\/span><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\"> = <\/span><\/p><p class=\"MsoNormal\" style=\"margin-bottom: 0cm; line-height: 13.5pt; background: #FFFFFE;\"><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: #4472c4; mso-themecolor: accent1;\">COUNTROWS<\/span><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\"> (<\/span><\/p><p class=\"MsoNormal\" style=\"margin-bottom: 0cm; line-height: 13.5pt; background: #FFFFFE;\"><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\">\u00a0\u00a0\u00a0 <\/span><span lang=\"EN-US\" style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: #4472c4; mso-themecolor: accent1; mso-ansi-language: EN-US;\">CALCULATETABLE<\/span><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\"> (<\/span><\/p><p class=\"MsoNormal\" style=\"margin-bottom: 0cm; line-height: 13.5pt; background: #FFFFFE;\"><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 fact_Sales,<\/span><\/p><p class=\"MsoNormal\" style=\"margin-bottom: 0cm; line-height: 13.5pt; background: #FFFFFE;\"><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 dim_Products[Productkey] = <\/span><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: #c00000;\">&#8220;Product A&#8221;<\/span><\/p><p class=\"MsoNormal\" style=\"margin-bottom: 0cm; line-height: 13.5pt; background: #FFFFFE;\"><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\">\u00a0\u00a0\u00a0 )<\/span><\/p><p class=\"MsoNormal\" style=\"margin-bottom: 0cm; line-height: 13.5pt; background: #FFFFFE;\"><span style=\"font-size: 9.0pt; font-family: Consolas; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; color: black; mso-fareast-language: #1000;\">)<\/span><\/p><p class=\"MsoNormal\"><span lang=\"EN-US\">\u00a0<\/span><\/p><p class=\"MsoNormal\">4.1 zal geen enkele context overgang uitvoeren, de evaluatie context blijft rij context. Rij context filtert niet. Ik herhaal: rij context filtert niet. Dus we krijgen gewoon een telling van alle Product A verkopen terug, voor alle klanten.<\/p><p class=\"MsoNormal\">\u00a0<\/p><p class=\"MsoNormal\">4.2, echter, zal de context overgang uitvoeren. Dus eerst wordt een filter op de klant in het datamodel toegepast en daarna wordt de evaluatie van de formule gedaan. Daarom zal dit resulteren in de telling van product A per klant.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-8f5e0ed elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8f5e0ed\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-6361924\" data-id=\"6361924\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a9bcf08 elementor-widget elementor-widget-image\" data-id=\"a9bcf08\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"data:image\/gif;base64,R0lGODlhAQABAIAAAAAAAP\/\/\/yH5BAEAAAAALAAAAAABAAEAAAIBRAA7\" data-src=\"https:\/\/minova.nl\/wp-content\/uploads\/2021\/10\/Picture4.png\" data-srcset=\"https:\/\/minova.nl\/wp-content\/uploads\/2021\/10\/Picture4.png 602w, https:\/\/minova.nl\/wp-content\/uploads\/2021\/10\/Picture4-300x78.png 300w\" width=\"600\" height=\"155\" class=\"attachment-large size-large wp-image-10840 lazyload\" alt=\"\" sizes=\"(max-width: 600px) 100vw, 600px\"><noscript><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"155\" src=\"https:\/\/minova.nl\/wp-content\/uploads\/2021\/10\/Picture4.png\" class=\"attachment-large size-large wp-image-10840\" alt=\"\" srcset=\"https:\/\/minova.nl\/wp-content\/uploads\/2021\/10\/Picture4.png 602w, https:\/\/minova.nl\/wp-content\/uploads\/2021\/10\/Picture4-300x78.png 300w\" sizes=\"(max-width: 600px) 100vw, 600px\"><\/noscript>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-79e14a1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"79e14a1\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-21f35fe\" data-id=\"21f35fe\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-7da69c4 elementor-widget elementor-widget-text-editor\" data-id=\"7da69c4\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Wilt u een Power BI Pro worden? Minova biedt Power BI incompany trainingen aan voor alle niveaus, van beginner tot gevorderde. Kijk op de trainingspagina voor meer informatie<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>In de wereld van DAX formules, zijn de twee formules die het meest door elkaar gehaald worden FILTER en CALCULATETABLE. Dat is te wijten aan het feit dat zij in bepaalde scenario&#8217;s eigenlijk hetzelfde resultaat opleveren. Bijvoorbeeld, wanneer een Matrix op het canvas wordt aangemaakt waarin een filter wordt toegepast op \u00e9\u00e9n dimensie tabel (in [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":10837,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[51],"tags":[],"class_list":["post-10816","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-power-bi-dax"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>DAX: Verschil tussen FILTER en CALCULATETABLE - Minova<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/minova.nl\/en\/dax-difference-between-filter-and-calculatetable\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"DAX: Verschil tussen FILTER en CALCULATETABLE - Minova\" \/>\n<meta property=\"og:description\" content=\"In de wereld van DAX formules, zijn de twee formules die het meest door elkaar gehaald worden FILTER en CALCULATETABLE. Dat is te wijten aan het feit dat zij in bepaalde scenario&#8217;s eigenlijk hetzelfde resultaat opleveren. Bijvoorbeeld, wanneer een Matrix op het canvas wordt aangemaakt waarin een filter wordt toegepast op \u00e9\u00e9n dimensie tabel (in [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/minova.nl\/en\/dax-difference-between-filter-and-calculatetable\/\" \/>\n<meta property=\"og:site_name\" content=\"Minova\" \/>\n<meta property=\"article:published_time\" content=\"2021-10-05T20:49:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-05-05T11:42:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/minova.nl\/wp-content\/uploads\/2021\/10\/FeatIm_Klein.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"682\" \/>\n\t<meta property=\"og:image:height\" content=\"384\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Marnix Jansen\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Marnix Jansen\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/minova.nl\\\/dax-verschil-tussen-filter-en-calculatetable\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/minova.nl\\\/dax-verschil-tussen-filter-en-calculatetable\\\/\"},\"author\":{\"name\":\"Marnix Jansen\",\"@id\":\"https:\\\/\\\/minova.nl\\\/#\\\/schema\\\/person\\\/7c1b3b83cdb1ccdb93c0816dd157f20e\"},\"headline\":\"DAX: Verschil tussen FILTER en CALCULATETABLE\",\"datePublished\":\"2021-10-05T20:49:58+00:00\",\"dateModified\":\"2023-05-05T11:42:05+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/minova.nl\\\/dax-verschil-tussen-filter-en-calculatetable\\\/\"},\"wordCount\":692,\"image\":{\"@id\":\"https:\\\/\\\/minova.nl\\\/dax-verschil-tussen-filter-en-calculatetable\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/minova.nl\\\/wp-content\\\/uploads\\\/2021\\\/10\\\/FeatIm_Klein.jpg\",\"articleSection\":[\"Power BI DAX\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/minova.nl\\\/dax-verschil-tussen-filter-en-calculatetable\\\/\",\"url\":\"https:\\\/\\\/minova.nl\\\/dax-verschil-tussen-filter-en-calculatetable\\\/\",\"name\":\"DAX: Verschil tussen FILTER en CALCULATETABLE - Minova\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/minova.nl\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/minova.nl\\\/dax-verschil-tussen-filter-en-calculatetable\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/minova.nl\\\/dax-verschil-tussen-filter-en-calculatetable\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/minova.nl\\\/wp-content\\\/uploads\\\/2021\\\/10\\\/FeatIm_Klein.jpg\",\"datePublished\":\"2021-10-05T20:49:58+00:00\",\"dateModified\":\"2023-05-05T11:42:05+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/minova.nl\\\/#\\\/schema\\\/person\\\/7c1b3b83cdb1ccdb93c0816dd157f20e\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/minova.nl\\\/dax-verschil-tussen-filter-en-calculatetable\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/minova.nl\\\/dax-verschil-tussen-filter-en-calculatetable\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/minova.nl\\\/dax-verschil-tussen-filter-en-calculatetable\\\/#primaryimage\",\"url\":\"https:\\\/\\\/minova.nl\\\/wp-content\\\/uploads\\\/2021\\\/10\\\/FeatIm_Klein.jpg\",\"contentUrl\":\"https:\\\/\\\/minova.nl\\\/wp-content\\\/uploads\\\/2021\\\/10\\\/FeatIm_Klein.jpg\",\"width\":682,\"height\":384},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/minova.nl\\\/dax-verschil-tussen-filter-en-calculatetable\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/minova.nl\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"DAX: Verschil tussen FILTER en CALCULATETABLE\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/minova.nl\\\/#website\",\"url\":\"https:\\\/\\\/minova.nl\\\/\",\"name\":\"Minova\",\"description\":\"Van data naar inzicht\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/minova.nl\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/minova.nl\\\/#\\\/schema\\\/person\\\/7c1b3b83cdb1ccdb93c0816dd157f20e\",\"name\":\"Marnix Jansen\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d0f8a0914d9cb667d4a598e0006a394cbe920eb4ec6356d0657ebcb790de8779?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d0f8a0914d9cb667d4a598e0006a394cbe920eb4ec6356d0657ebcb790de8779?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d0f8a0914d9cb667d4a598e0006a394cbe920eb4ec6356d0657ebcb790de8779?s=96&d=mm&r=g\",\"caption\":\"Marnix Jansen\"},\"sameAs\":[\"https:\\\/\\\/minova.nl\"],\"url\":\"https:\\\/\\\/minova.nl\\\/en\\\/author\\\/marnix\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"DAX: Difference between FILTER and CALCULATETABLE - Minova","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/minova.nl\/en\/dax-difference-between-filter-and-calculatetable\/","og_locale":"en_US","og_type":"article","og_title":"DAX: Verschil tussen FILTER en CALCULATETABLE - Minova","og_description":"In de wereld van DAX formules, zijn de twee formules die het meest door elkaar gehaald worden FILTER en CALCULATETABLE. Dat is te wijten aan het feit dat zij in bepaalde scenario&#8217;s eigenlijk hetzelfde resultaat opleveren. Bijvoorbeeld, wanneer een Matrix op het canvas wordt aangemaakt waarin een filter wordt toegepast op \u00e9\u00e9n dimensie tabel (in [&hellip;]","og_url":"https:\/\/minova.nl\/en\/dax-difference-between-filter-and-calculatetable\/","og_site_name":"Minova","article_published_time":"2021-10-05T20:49:58+00:00","article_modified_time":"2023-05-05T11:42:05+00:00","og_image":[{"width":682,"height":384,"url":"https:\/\/minova.nl\/wp-content\/uploads\/2021\/10\/FeatIm_Klein.jpg","type":"image\/jpeg"}],"author":"Marnix Jansen","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Marnix Jansen","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/minova.nl\/dax-verschil-tussen-filter-en-calculatetable\/#article","isPartOf":{"@id":"https:\/\/minova.nl\/dax-verschil-tussen-filter-en-calculatetable\/"},"author":{"name":"Marnix Jansen","@id":"https:\/\/minova.nl\/#\/schema\/person\/7c1b3b83cdb1ccdb93c0816dd157f20e"},"headline":"DAX: Verschil tussen FILTER en CALCULATETABLE","datePublished":"2021-10-05T20:49:58+00:00","dateModified":"2023-05-05T11:42:05+00:00","mainEntityOfPage":{"@id":"https:\/\/minova.nl\/dax-verschil-tussen-filter-en-calculatetable\/"},"wordCount":692,"image":{"@id":"https:\/\/minova.nl\/dax-verschil-tussen-filter-en-calculatetable\/#primaryimage"},"thumbnailUrl":"https:\/\/minova.nl\/wp-content\/uploads\/2021\/10\/FeatIm_Klein.jpg","articleSection":["Power BI DAX"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/minova.nl\/dax-verschil-tussen-filter-en-calculatetable\/","url":"https:\/\/minova.nl\/dax-verschil-tussen-filter-en-calculatetable\/","name":"DAX: Difference between FILTER and CALCULATETABLE - Minova","isPartOf":{"@id":"https:\/\/minova.nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/minova.nl\/dax-verschil-tussen-filter-en-calculatetable\/#primaryimage"},"image":{"@id":"https:\/\/minova.nl\/dax-verschil-tussen-filter-en-calculatetable\/#primaryimage"},"thumbnailUrl":"https:\/\/minova.nl\/wp-content\/uploads\/2021\/10\/FeatIm_Klein.jpg","datePublished":"2021-10-05T20:49:58+00:00","dateModified":"2023-05-05T11:42:05+00:00","author":{"@id":"https:\/\/minova.nl\/#\/schema\/person\/7c1b3b83cdb1ccdb93c0816dd157f20e"},"breadcrumb":{"@id":"https:\/\/minova.nl\/dax-verschil-tussen-filter-en-calculatetable\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/minova.nl\/dax-verschil-tussen-filter-en-calculatetable\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/minova.nl\/dax-verschil-tussen-filter-en-calculatetable\/#primaryimage","url":"https:\/\/minova.nl\/wp-content\/uploads\/2021\/10\/FeatIm_Klein.jpg","contentUrl":"https:\/\/minova.nl\/wp-content\/uploads\/2021\/10\/FeatIm_Klein.jpg","width":682,"height":384},{"@type":"BreadcrumbList","@id":"https:\/\/minova.nl\/dax-verschil-tussen-filter-en-calculatetable\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/minova.nl\/"},{"@type":"ListItem","position":2,"name":"DAX: Verschil tussen FILTER en CALCULATETABLE"}]},{"@type":"WebSite","@id":"https:\/\/minova.nl\/#website","url":"https:\/\/minova.nl\/","name":"Minova","description":"From data to insight","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/minova.nl\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/minova.nl\/#\/schema\/person\/7c1b3b83cdb1ccdb93c0816dd157f20e","name":"Marnix Jansen","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/d0f8a0914d9cb667d4a598e0006a394cbe920eb4ec6356d0657ebcb790de8779?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/d0f8a0914d9cb667d4a598e0006a394cbe920eb4ec6356d0657ebcb790de8779?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d0f8a0914d9cb667d4a598e0006a394cbe920eb4ec6356d0657ebcb790de8779?s=96&d=mm&r=g","caption":"Marnix Jansen"},"sameAs":["https:\/\/minova.nl"],"url":"https:\/\/minova.nl\/en\/author\/marnix\/"}]}},"_links":{"self":[{"href":"https:\/\/minova.nl\/en\/wp-json\/wp\/v2\/posts\/10816","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/minova.nl\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/minova.nl\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/minova.nl\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/minova.nl\/en\/wp-json\/wp\/v2\/comments?post=10816"}],"version-history":[{"count":30,"href":"https:\/\/minova.nl\/en\/wp-json\/wp\/v2\/posts\/10816\/revisions"}],"predecessor-version":[{"id":11088,"href":"https:\/\/minova.nl\/en\/wp-json\/wp\/v2\/posts\/10816\/revisions\/11088"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/minova.nl\/en\/wp-json\/wp\/v2\/media\/10837"}],"wp:attachment":[{"href":"https:\/\/minova.nl\/en\/wp-json\/wp\/v2\/media?parent=10816"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/minova.nl\/en\/wp-json\/wp\/v2\/categories?post=10816"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/minova.nl\/en\/wp-json\/wp\/v2\/tags?post=10816"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}