https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Tasa-de-rebote-ok-Tasa-de-rebote-en-funci%C3%B3n-del-valor-del-filtro/m-p/2716713#M82712 <P>Ésta tasa, es ok</P><P>&nbsp;</P><DIV><SPAN>Tasa de Rebote =</SPAN><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>ISBLANK</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN><SPAN>DIVIDE</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN><SPAN>CALCULATE</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN><SPAN>COUNT</SPAN><SPAN>(</SPAN><SPAN>TRebote</SPAN><SPAN>[TiempoSesion]</SPAN><SPAN>),&nbsp;</SPAN><SPAN>TRebote</SPAN><SPAN>[TiempoSesion]</SPAN><SPAN>&lt;&nbsp;</SPAN><SPAN>30</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ,</SPAN></DIV><BR /><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN><SPAN>DISTINCTCOUNT</SPAN><SPAN>(</SPAN><SPAN>Sesiones</SPAN><SPAN>[session_Id]</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )),&nbsp;</SPAN><SPAN>0</SPAN><SPAN>&nbsp;,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN><SPAN>DIVIDE</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN><SPAN>CALCULATE</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN><SPAN>COUNT</SPAN><SPAN>(</SPAN><SPAN>TRebote</SPAN><SPAN>[TiempoSesion]</SPAN><SPAN>),&nbsp;</SPAN><SPAN>TRebote</SPAN><SPAN>[TiempoSesion]</SPAN><SPAN>&lt;&nbsp;</SPAN><SPAN>30</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ,</SPAN></DIV><BR /><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN><SPAN>DISTINCTCOUNT</SPAN><SPAN>(</SPAN><SPAN>Sesiones</SPAN><SPAN>[session_Id]</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )</SPAN></DIV></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>Sin embargo, necesito que en función de un valor de un objeto visual, se calcule la tasa en base a la variable que se selecciona en el filtro visual, tengo ésto ... no me da error, pero no me calcula la tasa ,,, no sé bien qué hacer</SPAN></DIV><P>&nbsp;</P><P>&nbsp;</P><DIV><DIV><SPAN>Tasa de Rebote = </SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>VAR</SPAN> <SPAN>reb</SPAN><SPAN> = </SPAN><SPAN>SELECTEDVALUE</SPAN><SPAN>(</SPAN><SPAN>'Filtro Rebote'</SPAN><SPAN>[Filtro Rebote]</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>RETURN</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>reb</SPAN><SPAN>=</SPAN><SPAN>"&gt; 1.000 sesiones"</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>CALCULATE</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>ISBLANK</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>DIVIDE</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>CALCULATE</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>COUNT</SPAN><SPAN>(</SPAN><SPAN>TRebote</SPAN><SPAN>[TiempoSesion]</SPAN><SPAN>), </SPAN><SPAN>TRebote</SPAN><SPAN>[TiempoSesion]</SPAN><SPAN>&lt; </SPAN><SPAN>30</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ,</SPAN></DIV><BR /><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>DISTINCTCOUNT</SPAN><SPAN>(</SPAN><SPAN>Sesiones</SPAN><SPAN>[session_Id]</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )), </SPAN><SPAN>0</SPAN><SPAN> ,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>DIVIDE</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>CALCULATE</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>COUNT</SPAN><SPAN>(</SPAN><SPAN>TRebote</SPAN><SPAN>[TiempoSesion]</SPAN><SPAN>), </SPAN><SPAN>TRebote</SPAN><SPAN>[TiempoSesion]</SPAN><SPAN>&lt; </SPAN><SPAN>30</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ,</SPAN></DIV><BR /><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>DISTINCTCOUNT</SPAN><SPAN>(</SPAN><SPAN>Sesiones</SPAN><SPAN>[session_Id]</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ), </SPAN><SPAN>FILTER</SPAN><SPAN>(</SPAN><SPAN>Sesiones</SPAN><SPAN>, </SPAN><SPAN>Sesiones</SPAN><SPAN>[N Sesiones]</SPAN><SPAN>&gt;</SPAN><SPAN>1000</SPAN><SPAN>)))</SPAN></DIV></DIV> Mon, 22 Aug 2022 11:16:19 GMT Anonymous 2022-08-22T11:16:19Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Tasa-de-rebote-ok-Tasa-de-rebote-en-funci%C3%B3n-del-valor-del-filtro/m-p/2716713#M82712 <P>Ésta tasa, es ok</P><P>&nbsp;</P><DIV><SPAN>Tasa de Rebote =</SPAN><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>ISBLANK</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN><SPAN>DIVIDE</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN><SPAN>CALCULATE</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN><SPAN>COUNT</SPAN><SPAN>(</SPAN><SPAN>TRebote</SPAN><SPAN>[TiempoSesion]</SPAN><SPAN>),&nbsp;</SPAN><SPAN>TRebote</SPAN><SPAN>[TiempoSesion]</SPAN><SPAN>&lt;&nbsp;</SPAN><SPAN>30</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ,</SPAN></DIV><BR /><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN><SPAN>DISTINCTCOUNT</SPAN><SPAN>(</SPAN><SPAN>Sesiones</SPAN><SPAN>[session_Id]</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )),&nbsp;</SPAN><SPAN>0</SPAN><SPAN>&nbsp;,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN><SPAN>DIVIDE</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN><SPAN>CALCULATE</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN><SPAN>COUNT</SPAN><SPAN>(</SPAN><SPAN>TRebote</SPAN><SPAN>[TiempoSesion]</SPAN><SPAN>),&nbsp;</SPAN><SPAN>TRebote</SPAN><SPAN>[TiempoSesion]</SPAN><SPAN>&lt;&nbsp;</SPAN><SPAN>30</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ,</SPAN></DIV><BR /><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN><SPAN>DISTINCTCOUNT</SPAN><SPAN>(</SPAN><SPAN>Sesiones</SPAN><SPAN>[session_Id]</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )</SPAN></DIV></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>Sin embargo, necesito que en función de un valor de un objeto visual, se calcule la tasa en base a la variable que se selecciona en el filtro visual, tengo ésto ... no me da error, pero no me calcula la tasa ,,, no sé bien qué hacer</SPAN></DIV><P>&nbsp;</P><P>&nbsp;</P><DIV><DIV><SPAN>Tasa de Rebote = </SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>VAR</SPAN> <SPAN>reb</SPAN><SPAN> = </SPAN><SPAN>SELECTEDVALUE</SPAN><SPAN>(</SPAN><SPAN>'Filtro Rebote'</SPAN><SPAN>[Filtro Rebote]</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>RETURN</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>reb</SPAN><SPAN>=</SPAN><SPAN>"&gt; 1.000 sesiones"</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>CALCULATE</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>ISBLANK</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>DIVIDE</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>CALCULATE</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>COUNT</SPAN><SPAN>(</SPAN><SPAN>TRebote</SPAN><SPAN>[TiempoSesion]</SPAN><SPAN>), </SPAN><SPAN>TRebote</SPAN><SPAN>[TiempoSesion]</SPAN><SPAN>&lt; </SPAN><SPAN>30</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ,</SPAN></DIV><BR /><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>DISTINCTCOUNT</SPAN><SPAN>(</SPAN><SPAN>Sesiones</SPAN><SPAN>[session_Id]</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )), </SPAN><SPAN>0</SPAN><SPAN> ,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>DIVIDE</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>CALCULATE</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>COUNT</SPAN><SPAN>(</SPAN><SPAN>TRebote</SPAN><SPAN>[TiempoSesion]</SPAN><SPAN>), </SPAN><SPAN>TRebote</SPAN><SPAN>[TiempoSesion]</SPAN><SPAN>&lt; </SPAN><SPAN>30</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ,</SPAN></DIV><BR /><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>DISTINCTCOUNT</SPAN><SPAN>(</SPAN><SPAN>Sesiones</SPAN><SPAN>[session_Id]</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ), </SPAN><SPAN>FILTER</SPAN><SPAN>(</SPAN><SPAN>Sesiones</SPAN><SPAN>, </SPAN><SPAN>Sesiones</SPAN><SPAN>[N Sesiones]</SPAN><SPAN>&gt;</SPAN><SPAN>1000</SPAN><SPAN>)))</SPAN></DIV></DIV> Mon, 22 Aug 2022 11:16:19 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Tasa-de-rebote-ok-Tasa-de-rebote-en-funci%C3%B3n-del-valor-del-filtro/m-p/2716713#M82712 Anonymous 2022-08-22T11:16:19Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Tasa-de-rebote-ok-Tasa-de-rebote-en-funci%C3%B3n-del-valor-del-filtro/m-p/2725102#M83264 <P><FONT>Hi,&nbsp;Anonymous</LI-USER></FONT>&nbsp;</P> <P>Have you tried encapsulating the filter directly in the calculation?</P> <LI-CODE lang="markup">Tasa de Rebote = VAR reb = SELECTEDVALUE ( 'Filtro Rebote'[Filtro Rebote] ) RETURN IF ( reb = "&gt; 1.000 sesiones", IF ( ISBLANK ( DIVIDE ( CALCULATE ( COUNT ( TRebote[TiempoSesion] ), TRebote[TiempoSesion] &lt; 30, FILTER ( Sesiones, Sesiones[N Sesiones] &gt; 1000 ) ), CALCULATE ( DISTINCTCOUNT ( Sesiones[session_Id] ), FILTER ( Sesiones, Sesiones[N Sesiones] &gt; 1000 ) ) ) ), 0, DIVIDE ( CALCULATE ( COUNT ( TRebote[TiempoSesion] ), TRebote[TiempoSesion] &lt; 30, FILTER ( Sesiones, Sesiones[N Sesiones] &gt; 1000 ) ), CALCULATE ( DISTINCTCOUNT ( Sesiones[session_Id] ), FILTER ( Sesiones, Sesiones[N Sesiones] &gt; 1000 ) ) ) ) ) </LI-CODE> <P>Also check for typos&nbsp; in Value '&gt; 1,000 sessions' in 'Filtro Bounce' [Filtro Bounce].</P> <P>&nbsp;</P> <P><FONT>Best Regards,<BR />Community Support Team _ Eason</FONT></P> <P>&nbsp;</P> Thu, 25 Aug 2022 07:04:25 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Tasa-de-rebote-ok-Tasa-de-rebote-en-funci%C3%B3n-del-valor-del-filtro/m-p/2725102#M83264 v-easonf-msft 2022-08-25T07:04:25Z