https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Migration-of-Tableau-LOD-to-Power-bi/m-p/2134609#M48997 <P>Hi&nbsp;Anonymous</LI-USER>&nbsp;,</P><P>&nbsp;</P><P>It would help us to give answer more specifically if you could share some sample data with required output.</P><P>You can try below code:-</P><LI-CODE lang="markup">% Doc count = VAR distinct_count = CALCULATE ( DISTINCTCOUNT ( [count Doc] ) ) VAR total_count = CALCULATE ( COUNT ( [count Doc] ) ) RETURN DIVIDE ( distinct_count, total_count )</LI-CODE><P>&nbsp;</P><P>Thanks,</P><P>Samarth</P> Thu, 14 Oct 2021 09:53:09 GMT Samarth_18 2021-10-14T09:53:09Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Migration-of-Tableau-LOD-to-Power-bi/m-p/2134579#M48995 <P>Hi All,</P><P>&nbsp;</P><P>i need your help to build Dax using below Tableau Lod</P><P>&nbsp;</P><P>% Doc count =&nbsp;[count Doc] / TOTAL([count Doc])</P><P>&nbsp;</P><P>where "Count Doc" is distinct count of "docno"</P><P>&nbsp;</P><P>Thanks in advance.</P> Thu, 14 Oct 2021 09:37:19 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Migration-of-Tableau-LOD-to-Power-bi/m-p/2134579#M48995 Anonymous 2021-10-14T09:37:19Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Migration-of-Tableau-LOD-to-Power-bi/m-p/2134609#M48997 <P>Hi&nbsp;Anonymous</LI-USER>&nbsp;,</P><P>&nbsp;</P><P>It would help us to give answer more specifically if you could share some sample data with required output.</P><P>You can try below code:-</P><LI-CODE lang="markup">% Doc count = VAR distinct_count = CALCULATE ( DISTINCTCOUNT ( [count Doc] ) ) VAR total_count = CALCULATE ( COUNT ( [count Doc] ) ) RETURN DIVIDE ( distinct_count, total_count )</LI-CODE><P>&nbsp;</P><P>Thanks,</P><P>Samarth</P> Thu, 14 Oct 2021 09:53:09 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Migration-of-Tableau-LOD-to-Power-bi/m-p/2134609#M48997 Samarth_18 2021-10-14T09:53:09Z