https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Zero-counts/m-p/3790499#M148112 <P>I have stock exchange data in power bi.i have a measure that calculates whether closing price is maximum or not.if closing price is maximum this measure gives to the answer equall to zero.Now I want to count those zero in a separate measures</P> Tue, 26 Mar 2024 03:58:24 GMT MAP 2024-03-26T03:58:24Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Zero-counts/m-p/3790499#M148112 <P>I have stock exchange data in power bi.i have a measure that calculates whether closing price is maximum or not.if closing price is maximum this measure gives to the answer equall to zero.Now I want to count those zero in a separate measures</P> Tue, 26 Mar 2024 03:58:24 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Zero-counts/m-p/3790499#M148112 MAP 2024-03-26T03:58:24Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Zero-counts/m-p/3790504#M148113 <P>You could do this using SUMX and VALUES.&nbsp; First you'll need to understand what groupings will let you check a zero for.&nbsp; Maybe its a particular stockcode.&nbsp; Here is an example:</P><LI-CODE lang="c">Zero Count = SUMX( VALUES('Stocks'[Stock Code]), IF([Closing price max check] = 0, 1, 0) )</LI-CODE> Tue, 26 Mar 2024 04:02:19 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Zero-counts/m-p/3790504#M148113 Anonymous 2024-03-26T04:02:19Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Zero-counts/m-p/3792726#M148218 <P>Thank You Sir</P> Wed, 27 Mar 2024 03:40:13 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Zero-counts/m-p/3792726#M148218 MAP 2024-03-27T03:40:13Z