https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Tableau-LOD-calculation-to-DAX/m-p/3043330#M156617 <P>Hi,&nbsp;</P><P>&nbsp;</P><P>I am having trouble converting this tableau formula to DAX.&nbsp;</P><P>&nbsp;</P><P>Could you please help ?</P><P>&nbsp;</P><P><STRONG>Tableau calculation:&nbsp;</STRONG></P><P>&nbsp;</P><P>sum({ INCLUDE [Number] : countd(</P><P>if&nbsp;</P><P>[Country]='FRANCE'</P><P>and [Distance]&gt;0</P><P>then [Product Code]&nbsp;</P><P>END)})</P><P>/</P><P>COUNTD(</P><P>if</P><P>[Country]='FRANCE'</P><P>and [Flag Distance]</P><P>then [Number]</P><P>END)</P> Thu, 26 Jan 2023 12:16:59 GMT Anonymous 2023-01-26T12:16:59Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Tableau-LOD-calculation-to-DAX/m-p/3043330#M156617 <P>Hi,&nbsp;</P><P>&nbsp;</P><P>I am having trouble converting this tableau formula to DAX.&nbsp;</P><P>&nbsp;</P><P>Could you please help ?</P><P>&nbsp;</P><P><STRONG>Tableau calculation:&nbsp;</STRONG></P><P>&nbsp;</P><P>sum({ INCLUDE [Number] : countd(</P><P>if&nbsp;</P><P>[Country]='FRANCE'</P><P>and [Distance]&gt;0</P><P>then [Product Code]&nbsp;</P><P>END)})</P><P>/</P><P>COUNTD(</P><P>if</P><P>[Country]='FRANCE'</P><P>and [Flag Distance]</P><P>then [Number]</P><P>END)</P> Thu, 26 Jan 2023 12:16:59 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Tableau-LOD-calculation-to-DAX/m-p/3043330#M156617 Anonymous 2023-01-26T12:16:59Z