https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/More-than-function/m-p/1607850#M32287 <P>Hello&nbsp;Anonymous</LI-USER>&nbsp;,<BR />You can try this.<BR />Total Tickets =<BR />CALCULATE ( COUNT ( 'table'[Tickets] ), SUM ( 'table'[eventprice] ) &gt; 0 )<BR /><BR /></P> Tue, 19 Jan 2021 08:48:41 GMT Anonymous 2021-01-19T08:48:41Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/More-than-function/m-p/1607819#M32286 <P>Hi Power BI community,</P><P>&nbsp;</P><P>I am trying to find the number of paying patrons/ticket (i.e. eventprice &gt; $0) but I cannot reflect that on my card. Does anyone know how I can do that? Or what DAX formula I can use? Thanks in advance!</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P> Tue, 19 Jan 2021 08:28:22 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/More-than-function/m-p/1607819#M32286 Anonymous 2021-01-19T08:28:22Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/More-than-function/m-p/1607850#M32287 <P>Hello&nbsp;Anonymous</LI-USER>&nbsp;,<BR />You can try this.<BR />Total Tickets =<BR />CALCULATE ( COUNT ( 'table'[Tickets] ), SUM ( 'table'[eventprice] ) &gt; 0 )<BR /><BR /></P> Tue, 19 Jan 2021 08:48:41 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/More-than-function/m-p/1607850#M32287 Anonymous 2021-01-19T08:48:41Z