https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Current-Quarter-calculation/m-p/2771900#M86318 <P>Anonymous</LI-USER>&nbsp;Make your Yes/No slicer into a 2 rows in a disconnected table. Then construct a measure like:</P> <LI-CODE lang="markup">Measure = VAR __Current = SELECTEDVALUE('ParameterTable'[Column]) VAR __Value = IF( __Current = "Yes", SUMX(FILTER('Table',[Current Quarter] = "Yes"),[Value] SUM('Table'[Value]) ) RETURN __Value</LI-CODE> Fri, 16 Sep 2022 01:13:24 GMT Greg_Deckler 2022-09-16T01:13:24Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Current-Quarter-calculation/m-p/2771740#M86313 <DIV><DIV><SPAN>"Current Quarter"</SPAN><SPAN>, </SPAN><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>DATEDIFF</SPAN><SPAN>(</SPAN><SPAN>TODAY</SPAN><SPAN>(),</SPAN><SPAN>[Date]</SPAN><SPAN>,</SPAN><SPAN>QUARTER</SPAN><SPAN>)=</SPAN><SPAN>0</SPAN><SPAN>,</SPAN><SPAN>"Yes"</SPAN><SPAN>,</SPAN><SPAN>"No"</SPAN><SPAN>)</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>I am using this statement as a slicer in my powerbi report :</SPAN></DIV><DIV>&nbsp;</DIV><DIV><img /><P>&nbsp;</P><P>The problem when it we selecT yes it is showing correct data , when we press No , it is exculding the current quarter data :</P><P>&nbsp;</P><P>Thr requirement when selected current Yes display only current quarter , when selected No display all quarters including current quarter .</P></DIV></DIV> Thu, 15 Sep 2022 22:14:38 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Current-Quarter-calculation/m-p/2771740#M86313 Anonymous 2022-09-15T22:14:38Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Current-Quarter-calculation/m-p/2771900#M86318 <P>Anonymous</LI-USER>&nbsp;Make your Yes/No slicer into a 2 rows in a disconnected table. Then construct a measure like:</P> <LI-CODE lang="markup">Measure = VAR __Current = SELECTEDVALUE('ParameterTable'[Column]) VAR __Value = IF( __Current = "Yes", SUMX(FILTER('Table',[Current Quarter] = "Yes"),[Value] SUM('Table'[Value]) ) RETURN __Value</LI-CODE> Fri, 16 Sep 2022 01:13:24 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Current-Quarter-calculation/m-p/2771900#M86318 Greg_Deckler 2022-09-16T01:13:24Z