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
Super Useryou 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
ryan_mayu That does work. Thank you
However, I would need to create a new measure for every single column I want to use for the dynamic value text box.
For example, I would need the Countblank for Q5_1, Q5_2, Q18, etc. I have multiple visuals I want to add the text box to.
It doesn't seem like I am able to directly write into the dynamic value box to get the value.
- ryan_mayu
I think you can create a slicer. If you select the Qname, then the output will change automatically.
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 RegardsHi 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