Forum Discussion
Measures Count Blanks and Interaction Table Visual
Hi Anonymous ,
Please do like this.
1. Replace the 'null' value with '0' in 'Edit Query'.
2. Unpivot columns 'Variable2', 'Variable3', 'Variable4'.
3.Create a measure.
Please refer to my .pbix file.
Note: There must be an ‘Attribute’ column in the table visual, otherwise the interaction between the two visuals can not be completed.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super UserAnonymous
Can you share some sample data and the expected result to have a clear understanding of your question?
You can save your files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.
____________________________________
How to paste sample data with your question?
How to get your questions answered quickly?
_____________________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon if you like this reply 🙂
Hi, yes i replied to the message below with a better example and sample data!
v-lionel-msftCommunity Support
Hi Anonymous ,
Please do like this.
1. Replace the 'null' value with '0' in 'Edit Query'.
2. Unpivot columns 'Variable2', 'Variable3', 'Variable4'.
3.Create a measure.
Please refer to my .pbix file.
Note: There must be an ‘Attribute’ column in the table visual, otherwise the interaction between the two visuals can not be completed.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.