https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Excluding-zero-of-5-measures-in-a-matrix/m-p/1544829#M30489 <P>Hi Experts,</P><P>&nbsp;</P><P>I have one matrix and in it I have five measures and I want to exclude a row having zeros for all the measures. I have created a new measure and added all these measures and filter matrix data on this new measure using 'is not = 0'. But is it is not excluding rows with zeros for all the measures.&nbsp;</P><P>&nbsp;</P><P>Would appreciate your input.&nbsp;</P><P>&nbsp;</P><P>Many thanks!<img /></P> Fri, 11 Dec 2020 08:04:50 GMT ashrat001 2020-12-11T08:04:50Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Excluding-zero-of-5-measures-in-a-matrix/m-p/1544829#M30489 <P>Hi Experts,</P><P>&nbsp;</P><P>I have one matrix and in it I have five measures and I want to exclude a row having zeros for all the measures. I have created a new measure and added all these measures and filter matrix data on this new measure using 'is not = 0'. But is it is not excluding rows with zeros for all the measures.&nbsp;</P><P>&nbsp;</P><P>Would appreciate your input.&nbsp;</P><P>&nbsp;</P><P>Many thanks!<img /></P> Fri, 11 Dec 2020 08:04:50 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Excluding-zero-of-5-measures-in-a-matrix/m-p/1544829#M30489 ashrat001 2020-12-11T08:04:50Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Excluding-zero-of-5-measures-in-a-matrix/m-p/1546895#M30572 <P>From the general theory of computing: <STRONG>It's never advisable to compare floating point numbers with =</STRONG>. Floats are inherently inaccurate and rounding errors make such comparisons as a = b meaningless.</P> Sat, 12 Dec 2020 21:48:47 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Excluding-zero-of-5-measures-in-a-matrix/m-p/1546895#M30572 daxer-almighty 2020-12-12T21:48:47Z