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 KMiller ,
Thanks for reaching out to the Microsoft fabric community forum.
Please check if the number of ‘table name( column name)’ prompt Is giving the correct value related to your data.
If this works you can add the dynamic text value in multiple visuals.
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.
Thanks and Regards
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