I asked this question before but found a workaround. However, I would like to revisit this scenario in which I need to count rows returned to report that met or exceeded a “What if” threshold variance that I can change using a slider. Below is copy of the DAX which I would like to use but cannot filter on a Measure [Total Cost TY] > 0. I populate this measure with a value for items that met or exceeded the threshold variance, otherwise it is set to blank. I have attached a demo model with the error I’m getting, page name is “Var PCT Increase (Cost Type).” The result I expect is 10, which is the number of rows returned with variance >= 53% increase in cost TY vs LY. Could you please take a look and let me know of any options to fix this error?
VAR EXP CNT = CALCULATE( COUNTROWS('APPLICATION COST'), FILTER( ALL('Key Measures'), [Total Cost TY] > 0 ))
The workaround is under page “Var PCT Increase (TOT Cost)” where I added a new column to the report called “Var APP CNT” and turned on subtotals to get my application count number.