https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/COUNT-the-MAXIMUM/m-p/1700128#M35002 <P>hi maye this?</P><LI-CODE lang="markup">mCount:=CALCULATE(COUNTROWS(values(Table1[orderid])))</LI-CODE><P>&nbsp;</P><P><img /></P><P>&nbsp;</P> Wed, 03 Mar 2021 07:36:13 GMT rfigtree 2021-03-03T07:36:13Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/COUNT-the-MAXIMUM/m-p/1699097#M34985 <P>PLEASE HELP!!</P><P>... with a formula that I´m having a hard time solving.</P><P>I have three measurements: "Date", "OrderID" and "Medical History".</P><P>I need to COUNT the MAXIMUM "OrderID" (Different Records), among "Clinical History", of each "Date".</P><P>I mean, among several numbers of "OrderID", if "Medical Record"number is repeated by day&nbsp;("Date"), COUNT the MAXIMUM number of "OrderID".</P><P>&nbsp;</P><P>Thanks!!!</P> Tue, 02 Mar 2021 17:01:34 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/COUNT-the-MAXIMUM/m-p/1699097#M34985 Cesar_Zeta 2021-03-02T17:01:34Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/COUNT-the-MAXIMUM/m-p/1700128#M35002 <P>hi maye this?</P><LI-CODE lang="markup">mCount:=CALCULATE(COUNTROWS(values(Table1[orderid])))</LI-CODE><P>&nbsp;</P><P><img /></P><P>&nbsp;</P> Wed, 03 Mar 2021 07:36:13 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/COUNT-the-MAXIMUM/m-p/1700128#M35002 rfigtree 2021-03-03T07:36:13Z