https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Filter-Help/m-p/3217927#M117529 <P>Hi amandabus21,</P><P>&nbsp;</P><P>Any information at all about your data and/or data model would probably be helpful. <A href="https://community.powerbi.com/t5/DAX-Commands-and-Tips/How-to-Get-Your-Question-Answered-Quickly/td-p/1626726/jump-to/first-unread-message" target="_self">This post by Greg Deckler</A> might be able to give you some pointers. <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Wed, 03 May 2023 13:28:26 GMT Wilson_ 2023-05-03T13:28:26Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Filter-Help/m-p/3216638#M117449 <P>Have this formula, but when I insert a slicer " Bus Equipment Key" to pick one, the formula just zeros out.&nbsp;</P><P>&nbsp;</P><DIV><DIV><SPAN>Difference # = </SPAN></DIV><DIV><SPAN>VAR</SPAN> <SPAN>FirstSelectedDate</SPAN><SPAN> =</SPAN></DIV><DIV><SPAN>CALCULATE</SPAN><SPAN> (</SPAN></DIV><DIV><SPAN>MIN</SPAN><SPAN> ( </SPAN><SPAN>'PM On Time Performance Bus PM-BI-002 (2)'</SPAN><SPAN>[Completion Date.Completion Date Level 01]</SPAN><SPAN> ),</SPAN></DIV><DIV><SPAN>ALLSELECTED</SPAN><SPAN>(),</SPAN></DIV><DIV><SPAN>VALUES</SPAN><SPAN> ( </SPAN><SPAN>'PM On Time Performance Bus PM-BI-002 (2)'</SPAN><SPAN>[Equipment.Equipment Level 01.Key]</SPAN><SPAN> )</SPAN></DIV><DIV><SPAN>)</SPAN></DIV><DIV><SPAN>RETURN</SPAN></DIV><DIV><SPAN>SUMX</SPAN><SPAN> (</SPAN></DIV><DIV><SPAN>'PM On Time Performance Bus PM-BI-002 (2)'</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>IF</SPAN><SPAN> (</SPAN></DIV><DIV><SPAN>'PM On Time Performance Bus PM-BI-002 (2)'</SPAN><SPAN>[Completion Date.Completion Date Level 01]</SPAN><SPAN> = </SPAN><SPAN>FirstSelectedDate</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>0</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>'PM On Time Performance Bus PM-BI-002 (2)'</SPAN><SPAN>[Variable Difference]</SPAN></DIV><DIV><SPAN>)</SPAN></DIV><DIV><SPAN>)</SPAN></DIV></DIV> Tue, 02 May 2023 22:13:21 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Filter-Help/m-p/3216638#M117449 amandabus21 2023-05-02T22:13:21Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Filter-Help/m-p/3217927#M117529 <P>Hi amandabus21,</P><P>&nbsp;</P><P>Any information at all about your data and/or data model would probably be helpful. <A href="https://community.powerbi.com/t5/DAX-Commands-and-Tips/How-to-Get-Your-Question-Answered-Quickly/td-p/1626726/jump-to/first-unread-message" target="_self">This post by Greg Deckler</A> might be able to give you some pointers. <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Wed, 03 May 2023 13:28:26 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Filter-Help/m-p/3217927#M117529 Wilson_ 2023-05-03T13:28:26Z