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.
Community SupportHi Anonymous ,
Is this the problem you encountered?
According to statistics, ID 1 has 10 blank records, but only 1 row is displayed in the table visual.
If yes, please add an index column in 'Edit Query'.
If not, please post your sample data.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Not exactly, what I mean is the following:
Here the donut chart displays three measures calculated as "Variable 2 empty = COUNTBLANK(Sheet1[Variable 2])".
I want to then check what are the ids of these 4 records who have a blank field on variable 2. So I want click on that part of the donut chart and then in the table below only see the 4 ids for which variable 2 is empty. Likewise for the other measures if selected in the donut chart.
Adding the measure itself to the table does not solve the issues as there are different "empty" measures I am using.
Sample Data:
| ID | Variable 2 | Variable 3 | Variable 4 |
| 1123 | aa | x | |
| 4135 | x | 78 | |
| 1334 | bb | 36 | |
| 4562 | y | 87 | |
| 4567 | x | ||
| 8901 | y |
Thanks all for trying to help.