https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-keep-raw-total/m-p/1899588#M40961 <P>Why do you want to keep this value? Is it for the current week? What kind of slicers?</P> Mon, 14 Jun 2021 17:52:00 GMT Gabriel_Walkman 2021-06-14T17:52:00Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-keep-raw-total/m-p/1898440#M40936 <P>HI,</P><P>&nbsp;</P><P>im trying to get a measure that is based on other measure that will ignore all page slicers and interactions , and only will filter to current raw in the table.</P><P>&nbsp;</P><P>the base measure i have :&nbsp;</P><DIV><DIV><SPAN># Log Changes = CALCULATE( DISTINCTCOUNT(FactStatusLog[Issue Key]), FactStatusLog[LastStatusOfWeek]="1",FactStatusLog[isLast]=1)</SPAN></DIV><DIV>my table:</DIV><DIV><img /><P>i want to keep the "193" for this raw level of "YEAR&amp;WORKWEEK" but if i will press on slicer on the page that it will not changed remain "193"</P><P>&nbsp;</P><P>thanks</P></DIV></DIV> Mon, 14 Jun 2021 09:13:12 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-keep-raw-total/m-p/1898440#M40936 ofirnayman 2021-06-14T09:13:12Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-keep-raw-total/m-p/1899588#M40961 <P>Why do you want to keep this value? Is it for the current week? What kind of slicers?</P> Mon, 14 Jun 2021 17:52:00 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-keep-raw-total/m-p/1899588#M40961 Gabriel_Walkman 2021-06-14T17:52:00Z