Forum Discussion
Count non blank rows in the dynamic value text box
you can use countrows to count all rows
https://learn.microsoft.com/en-us/dax/countrows-function-dax?wt.mc_id=DP-MVP-5004616
use countblank to count blank rows
https://learn.microsoft.com/en-us/dax/countblank-function-dax?wt.mc_id=DP-MVP-5004616
then non blank = all rows - blank rows
Hi Anonymous that gives me the unique values in that column. Still not exactly what I need. Good information to have though, thank you.
Hi KMiller ,
If the dynamic text value isn't meeting your specific requirements, you can achieve the desired result using the technique mentioned by ryan_mayu leveraging countrows and countblank. The main limitation of this approach is that it requires creating a separate measure for each column, but unfortunately, that's a constraint we have to work with.
If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS. Feel free to reach out if you need further assistance.
Thank you