https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Count-records-based-on-most-recent-record/m-p/3164535#M113752 <P style="margin: 0in; font-family: tahoma; font-size: 11.0pt;">Hi <a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="210416" data-lia-user-login="2366" class="lia-mention lia-mention-user">2366</a>&nbsp;,</P> <P style="margin: 0in; font-family: tahoma; font-size: 11.0pt;">Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.</P> <P style="margin: 0in; font-family: tahoma; font-size: 11.0pt;"><A href="http://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490" target="_blank">How to Get Your Question Answered Quickly&nbsp;</A>&nbsp;</P> <P style="margin: 0in; font-family: tahoma; font-size: 11.0pt;">Regards,</P> <P style="margin: 0in; font-family: tahoma; font-size: 11.0pt;">Xiaoxin Sheng</P> Fri, 31 Mar 2023 01:20:11 GMT Anonymous 2023-03-31T01:20:11Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Count-records-based-on-most-recent-record/m-p/3159856#M113438 <P>Hello,</P><P>&nbsp;</P><P>my model has a tablet which tracks different attributes of an employee, such as, designation, employment status, department, region, effective date.</P><P><BR />the table doesn't have a relationship with date dimension.</P><P>&nbsp;</P><P>Can you please suggest if I can create a DAX measure which only filters for the latest record based on employeeid's effective date and displays counts against any dimension like, region, status, department I select?</P><P>&nbsp;</P><P>thanks</P> Wed, 29 Mar 2023 04:07:30 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Count-records-based-on-most-recent-record/m-p/3159856#M113438 2366 2023-03-29T04:07:30Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Count-records-based-on-most-recent-record/m-p/3164535#M113752 <P style="margin: 0in; font-family: tahoma; font-size: 11.0pt;">Hi <a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="210416" data-lia-user-login="2366" class="lia-mention lia-mention-user">2366</a>&nbsp;,</P> <P style="margin: 0in; font-family: tahoma; font-size: 11.0pt;">Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.</P> <P style="margin: 0in; font-family: tahoma; font-size: 11.0pt;"><A href="http://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490" target="_blank">How to Get Your Question Answered Quickly&nbsp;</A>&nbsp;</P> <P style="margin: 0in; font-family: tahoma; font-size: 11.0pt;">Regards,</P> <P style="margin: 0in; font-family: tahoma; font-size: 11.0pt;">Xiaoxin Sheng</P> Fri, 31 Mar 2023 01:20:11 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Count-records-based-on-most-recent-record/m-p/3164535#M113752 Anonymous 2023-03-31T01:20:11Z