Im currrently doing a report that checks specific fields and see if that contains data or not.
| Field: | Contains no data: | Contains
data: |
| Name | 0 | 82.743 |
| Industry Sector | 19 | 82.724 |
| Phone | 55.927 | 26.816 |
| Email | 69.983 | 12.760 |
| Website | 82.691 | 52 |
So i created two measure per field: one that counts blank columns and the other one that counts the column containing data.
My problem is i need to show what are those records having blanks. I used table visual and whenever i click the Blank Phone column, i doesnt filter the table, it just refreshed.
| Organization | Blank Names | Names with Data | Blank Phone | Phone with Data |
| A | 0,00 | 27581,00 | 43234,00 | 1450,00 |
| B | 0,00 | 34290,00 | 231,00 | 5692,00 |
| C | 0,00 | 20872,00 | 12462,00 | 19674,00 |
