{"id":85,"date":"2023-05-18T07:25:09","date_gmt":"2023-05-18T07:25:09","guid":{"rendered":"https:\/\/datadandies.nl\/?p=85"},"modified":"2023-05-18T07:25:09","modified_gmt":"2023-05-18T07:25:09","slug":"dax-variables","status":"publish","type":"post","link":"https:\/\/datadandies.nl\/index.php\/2023\/05\/18\/dax-variables\/","title":{"rendered":"DAX Variables"},"content":{"rendered":"\n<p>Careful with DAX variables. Variables defined OUTSIDE of expressions have already been computed. If you wish to modify the value of the variable with CALCULATE, you have to define the variable INSIDE of the expression. See below for an example.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"773\" height=\"510\" src=\"https:\/\/datadandies.nl\/wp-content\/uploads\/2023\/05\/20220821-Variables-DAX.jpg\" alt=\"\" class=\"wp-image-86\" srcset=\"https:\/\/datadandies.nl\/wp-content\/uploads\/2023\/05\/20220821-Variables-DAX.jpg 773w, https:\/\/datadandies.nl\/wp-content\/uploads\/2023\/05\/20220821-Variables-DAX-300x198.jpg 300w, https:\/\/datadandies.nl\/wp-content\/uploads\/2023\/05\/20220821-Variables-DAX-768x507.jpg 768w\" sizes=\"auto, (max-width: 773px) 100vw, 773px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Careful with DAX variables. Variables defined OUTSIDE of expressions have already been computed. If you wish to modify the value of the variable with CALCULATE, you have to define the variable INSIDE of the expression. See below for an example.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[6,3,7],"class_list":["post-85","post","type-post","status-publish","format-standard","hentry","category-blog","tag-dax","tag-powerbi","tag-variables"],"_links":{"self":[{"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/posts\/85","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/comments?post=85"}],"version-history":[{"count":1,"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/posts\/85\/revisions"}],"predecessor-version":[{"id":87,"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/posts\/85\/revisions\/87"}],"wp:attachment":[{"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/media?parent=85"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/categories?post=85"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/tags?post=85"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}