topic Re: DAX vs MDX in Report Server https://community.fabric.microsoft.com/t5/Report-Server/DAX-vs-MDX/m-p/3571453#M31977 <P>There are no real disadvantages to using DAX against a tabular model. DAX is the native expression language for tabular models. But there are a couple of disadvantages to using MDX</P> <P>&nbsp;</P> <OL> <LI>MDX has different semantics, so there are extra steps that need to be done when a tabular model evaluates an MDX query that are not needed when evaluating DAX - resulting in slower performance</LI> <LI>MDX returns multi-dimensional cellsets which have to go through a process called flattening to be consumed by SSRS which also adds extra overhead.</LI> </OL> Wed, 06 Dec 2023 23:44:07 GMT d_gosbell 2023-12-06T23:44:07Z DAX vs MDX https://community.fabric.microsoft.com/t5/Report-Server/DAX-vs-MDX/m-p/3568492#M31966 <P><SPAN>What are the advantages and disadvantages of using DAX instead of MDX in SSRS (with tabular cubes)?</SPAN></P> Tue, 05 Dec 2023 13:29:39 GMT https://community.fabric.microsoft.com/t5/Report-Server/DAX-vs-MDX/m-p/3568492#M31966 claudiassmatos7 2023-12-05T13:29:39Z Re: DAX vs MDX https://community.fabric.microsoft.com/t5/Report-Server/DAX-vs-MDX/m-p/3571453#M31977 <P>There are no real disadvantages to using DAX against a tabular model. DAX is the native expression language for tabular models. But there are a couple of disadvantages to using MDX</P> <P>&nbsp;</P> <OL> <LI>MDX has different semantics, so there are extra steps that need to be done when a tabular model evaluates an MDX query that are not needed when evaluating DAX - resulting in slower performance</LI> <LI>MDX returns multi-dimensional cellsets which have to go through a process called flattening to be consumed by SSRS which also adds extra overhead.</LI> </OL> Wed, 06 Dec 2023 23:44:07 GMT https://community.fabric.microsoft.com/t5/Report-Server/DAX-vs-MDX/m-p/3571453#M31977 d_gosbell 2023-12-06T23:44:07Z Re: DAX vs MDX https://community.fabric.microsoft.com/t5/Report-Server/DAX-vs-MDX/m-p/3572795#M31982 <P>Thank you!</P> Thu, 07 Dec 2023 15:15:11 GMT https://community.fabric.microsoft.com/t5/Report-Server/DAX-vs-MDX/m-p/3572795#M31982 claudiassmatos7 2023-12-07T15:15:11Z