https://community.fabric.microsoft.com/t5/Developer/Dashboard-Creation/m-p/3401609#M44115 <P>Hi&nbsp;<a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/607620">@vksk0338</a>&nbsp;,</P> <P>You can create a <STRONG>measure</STRONG> as below to get the same result in Power BI with the one(<SPAN>&nbsp;<EM>{ fixed [Filedate] : COUNTD([Agreementid]) }</EM></SPAN>) in Tableau.</P> <LI-CODE lang="markup">Count Distinct Agreementid by Filedate = CALCULATE ( DISTINCTCOUNT ( 'Table'[Agreementid] ), ALLEXCEPT ( 'Table', 'Table'[Filedate] ) )</LI-CODE> <P>Best Regards</P> Mon, 28 Aug 2023 06:36:13 GMT Anonymous 2023-08-28T06:36:13Z https://community.fabric.microsoft.com/t5/Developer/Dashboard-Creation/m-p/3396245#M44052 <P>There is a concept of LOD in Tableau.What's the similar concept in PowerBI. I want to fix at certain level of Detail.</P><P>The Query used in Tableau is :- { fixed [Filedate] : COUNTD([Agreementid]) }.Whats the DAX Query in Power BI?</P> Thu, 24 Aug 2023 06:12:50 GMT https://community.fabric.microsoft.com/t5/Developer/Dashboard-Creation/m-p/3396245#M44052 vksk0338 2023-08-24T06:12:50Z https://community.fabric.microsoft.com/t5/Developer/Dashboard-Creation/m-p/3401609#M44115 <P>Hi&nbsp;<a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/607620">@vksk0338</a>&nbsp;,</P> <P>You can create a <STRONG>measure</STRONG> as below to get the same result in Power BI with the one(<SPAN>&nbsp;<EM>{ fixed [Filedate] : COUNTD([Agreementid]) }</EM></SPAN>) in Tableau.</P> <LI-CODE lang="markup">Count Distinct Agreementid by Filedate = CALCULATE ( DISTINCTCOUNT ( 'Table'[Agreementid] ), ALLEXCEPT ( 'Table', 'Table'[Filedate] ) )</LI-CODE> <P>Best Regards</P> Mon, 28 Aug 2023 06:36:13 GMT https://community.fabric.microsoft.com/t5/Developer/Dashboard-Creation/m-p/3401609#M44115 Anonymous 2023-08-28T06:36:13Z