1.0Xelplus - Leila Gharanihttps://www.xelplus.comLeila Gharanihttps://www.xelplus.com/author/xelplus/How to Do Many-to-One Side Calculations in Data Models with DAXrich600338<blockquote class="wp-embedded-content" data-secret="oibJFTizWB"><a href="https://www.xelplus.com/dax-many-to-one-side-calculations/">How to Do Many-to-One Side Calculations in Data Models with DAX</a></blockquote><iframe sandbox="allow-scripts" security="restricted" src="https://www.xelplus.com/dax-many-to-one-side-calculations/embed/#?secret=oibJFTizWB" width="600" height="338" title="“How to Do Many-to-One Side Calculations in Data Models with DAX” — Xelplus - Leila Gharani" data-secret="oibJFTizWB" frameborder="0" marginwidth="0" marginheight="0" scrolling="no" class="wp-embedded-content"></iframe><script>
/*! This file is auto-generated */
!function(d,l){"use strict";l.querySelector&&d.addEventListener&&"undefined"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!/[^a-zA-Z0-9]/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret="'+t.secret+'"]'),o=l.querySelectorAll('blockquote[data-secret="'+t.secret+'"]'),c=new RegExp("^https?:$","i"),i=0;i<o.length;i++)o[i].style.display="none";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute("style"),"height"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):"link"===t.message&&(r=new URL(s.getAttribute("src")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener("message",d.wp.receiveEmbedMessage,!1),l.addEventListener("DOMContentLoaded",function(){for(var e,t,s=l.querySelectorAll("iframe.wp-embedded-content"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute("data-secret"))||(t=Math.random().toString(36).substring(2,12),e.src+="#?secret="+t,e.setAttribute("data-secret",t)),e.contentWindow.postMessage({message:"ready",secret:t},"*")},!1)))}(window,document);
</script>
https://www.xelplus.com/wp-content/uploads/2022/03/blogicon_DAX_ManyToOne_1.jpg800450In Power BI or Power Pivot, you often need to create reports that go from the many side of the relationship to the one side. How can you do that without expanding your data model by adding more columns to your table? There is an easy trick you can use to solve this with a single DAX formula. Of course, the formula uses the CALCULATE function.