https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/I-have-a-problem-with-removefilter/m-p/4067764#M161489 <P>You need a dimension table for the column you are trying to remove. You cannot acheive the result you want by using REMOVEFILTER over a fact table.&nbsp;<BR /><BR /></P><P>read my article here for what you should aim for.&nbsp;<A href="https://exceleratorbi.com.au/the-optimal-shape-for-power-pivot-data/" target="_blank">https://exceleratorbi.com.au/the-optimal-shape-for-power-pivot-data/</A></P> Mon, 29 Jul 2024 22:08:00 GMT MattAllington 2024-07-29T22:08:00Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/I-have-a-problem-with-removefilter/m-p/4067652#M161485 <DIV><DIV><SPAN>I have this code:<BR /><BR />Total Receipts Ignoring Amount Filter = </SPAN></DIV><DIV><SPAN>CALCULATE</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>DISTINCTCOUNT</SPAN><SPAN>(Sales[Чек]),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>REMOVEFILTERS</SPAN><SPAN>(Sales[Сума до сплати]),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; Sales[Сума до сплати] &gt; </SPAN><SPAN>0</SPAN></DIV><DIV><SPAN>)<BR />My task is to create a measure that will not react to the cutoff by [Сума до сплати]. But this measure still reacts to this cutoff. How can this be fixed?<BR /><BR /></SPAN></DIV></DIV> Mon, 29 Jul 2024 19:25:26 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/I-have-a-problem-with-removefilter/m-p/4067652#M161485 NazarBorodin 2024-07-29T19:25:26Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/I-have-a-problem-with-removefilter/m-p/4067764#M161489 <P>You need a dimension table for the column you are trying to remove. You cannot acheive the result you want by using REMOVEFILTER over a fact table.&nbsp;<BR /><BR /></P><P>read my article here for what you should aim for.&nbsp;<A href="https://exceleratorbi.com.au/the-optimal-shape-for-power-pivot-data/" target="_blank">https://exceleratorbi.com.au/the-optimal-shape-for-power-pivot-data/</A></P> Mon, 29 Jul 2024 22:08:00 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/I-have-a-problem-with-removefilter/m-p/4067764#M161489 MattAllington 2024-07-29T22:08:00Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/I-have-a-problem-with-removefilter/m-p/4070887#M161612 <P>If it is&nbsp;<EM>not</EM> linked to a dimension table (see previous comment), try using ALL instead of REMOVEFILTERS.</P> Wed, 31 Jul 2024 08:42:55 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/I-have-a-problem-with-removefilter/m-p/4070887#M161612 sjoerdvn 2024-07-31T08:42:55Z