How to display fields with missing or no data?

[Anonymous]

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

[v-viig]

It seems this issue is not related to Custom Visuals.

Please create a new topic here.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

[email protected]