https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/total-count-of-member-with-more-than-X-number-of-UNIQUE-case-ID/m-p/3069328#M106422 <P>Member&nbsp; &nbsp; &nbsp; case ID<BR />jim&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;a1<BR />jim&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;a1<BR />jim&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;a1<BR />jim&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;a2<BR />jim&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;a3<BR />bob&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;b1<BR />bob&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;b1<BR />bob&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;b2<BR />sam&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;c1<BR />sam&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;c2<BR />sam&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;c3</P><P>&nbsp;</P><P>Hello Experts</P><P>I'd like a measure that will show</P><P>&nbsp;</P><P>Total number of members with 3 and up UNIQUE case IDs, in this case = 2 (jim and sam)</P><P>&nbsp;</P><P>thank you</P><P>&nbsp;</P><P>&nbsp;</P> Wed, 08 Feb 2023 14:43:04 GMT konijay 2023-02-08T14:43:04Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/total-count-of-member-with-more-than-X-number-of-UNIQUE-case-ID/m-p/3069328#M106422 <P>Member&nbsp; &nbsp; &nbsp; case ID<BR />jim&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;a1<BR />jim&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;a1<BR />jim&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;a1<BR />jim&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;a2<BR />jim&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;a3<BR />bob&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;b1<BR />bob&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;b1<BR />bob&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;b2<BR />sam&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;c1<BR />sam&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;c2<BR />sam&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;c3</P><P>&nbsp;</P><P>Hello Experts</P><P>I'd like a measure that will show</P><P>&nbsp;</P><P>Total number of members with 3 and up UNIQUE case IDs, in this case = 2 (jim and sam)</P><P>&nbsp;</P><P>thank you</P><P>&nbsp;</P><P>&nbsp;</P> Wed, 08 Feb 2023 14:43:04 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/total-count-of-member-with-more-than-X-number-of-UNIQUE-case-ID/m-p/3069328#M106422 konijay 2023-02-08T14:43:04Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/total-count-of-member-with-more-than-X-number-of-UNIQUE-case-ID/m-p/3069421#M106425 <P>hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="511614" data-lia-user-login="konijay" class="lia-mention lia-mention-user">konijay</a>&nbsp;</P><P>try like:</P><LI-CODE lang="markup">Measure = VAR _table = ADDCOLUMNS( VALUES(TableName[Member]), "Count", CALCULATE(DISTINCTCOUNT(TableName[Case ID])) ) RETURN COUNTROWS( FILTER(_table, [Count]&gt;=3) )</LI-CODE> Wed, 08 Feb 2023 15:12:29 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/total-count-of-member-with-more-than-X-number-of-UNIQUE-case-ID/m-p/3069421#M106425 FreemanZ 2023-02-08T15:12:29Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/total-count-of-member-with-more-than-X-number-of-UNIQUE-case-ID/m-p/3069453#M106427 <P>LOVE U!</P> Wed, 08 Feb 2023 15:24:16 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/total-count-of-member-with-more-than-X-number-of-UNIQUE-case-ID/m-p/3069453#M106427 konijay 2023-02-08T15:24:16Z