https://community.fabric.microsoft.com/t5/Report-Server/scheduled-refresh-causes-countax-measure-to-not-return-a-value/m-p/1455682#M16408 <P>I have several cards with measures in my report. One is a countax measure. It works fine in Power BI desktop and it works when I publish it. But when the published report refreshes, the data for that measure doesn't return a value. If I republish the report, then the data shows up. Here's the formula:</P><P>&nbsp;</P><DIV><DIV><SPAN>ID'd = COUNTAX(filter('Latents', [Latent Print Identif]="True"),[Id])+0</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>[Latent Print Identif] is a text column. </SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>I have some COUNTA formulas and those do recalculate correctly when the refresh occurs. It's just this one that doesn't work.&nbsp;</SPAN></DIV></DIV> Mon, 26 Oct 2020 15:03:16 GMT DEnderle 2020-10-26T15:03:16Z https://community.fabric.microsoft.com/t5/Report-Server/scheduled-refresh-causes-countax-measure-to-not-return-a-value/m-p/1455682#M16408 <P>I have several cards with measures in my report. One is a countax measure. It works fine in Power BI desktop and it works when I publish it. But when the published report refreshes, the data for that measure doesn't return a value. If I republish the report, then the data shows up. Here's the formula:</P><P>&nbsp;</P><DIV><DIV><SPAN>ID'd = COUNTAX(filter('Latents', [Latent Print Identif]="True"),[Id])+0</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>[Latent Print Identif] is a text column. </SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>I have some COUNTA formulas and those do recalculate correctly when the refresh occurs. It's just this one that doesn't work.&nbsp;</SPAN></DIV></DIV> Mon, 26 Oct 2020 15:03:16 GMT https://community.fabric.microsoft.com/t5/Report-Server/scheduled-refresh-causes-countax-measure-to-not-return-a-value/m-p/1455682#M16408 DEnderle 2020-10-26T15:03:16Z https://community.fabric.microsoft.com/t5/Report-Server/scheduled-refresh-causes-countax-measure-to-not-return-a-value/m-p/2146082#M21400 <P>I'm having the same issue - anyone find a fix for this?</P> Wed, 20 Oct 2021 15:29:38 GMT https://community.fabric.microsoft.com/t5/Report-Server/scheduled-refresh-causes-countax-measure-to-not-return-a-value/m-p/2146082#M21400 CJHM85 2021-10-20T15:29:38Z