Count non blank rows in the dynamic value text box

[KMiller]

I would like to use the dynamic value in the text box to count the number of responses I have for each question. Q5_1 and Q5_2 are both text columns.

For example, Q5_1 has 100 rows with responses. I want the text to be "N = 100"

Q5_2 only has 76 responses so N = 76

    

[v-nmadadi-msft]

Hi @KMiller 

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[ryan_mayu · Accepted solution]

@KMiller 

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

[KMiller]

@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.

[v-nmadadi-msft]

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

[KMiller]

Hi @v-nmadadi-msft that gives me the unique values in that column. Still not exactly what I need. Good information to have though, thank you.

[v-nmadadi-msft]

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

[ryan_mayu]

I think you can create a slicer. If you select the Qname, then the output will change automatically.