Count Blanks related to different table

[Dan_Wis]

Hi,

How to count percentage of blank values having:

1. In one (main) table I have, apart from other coulmns: "ID". The table has appx 30 k rows.

ID	Country
1	UK
2	DE
3	SE
4	UK
5	NO
6	UK
7	BE
8	ES
9	SE
10	DK
11	DE
12	ES

2. Table2 with: single values in ID column only with non blank entries in Date column - say 6k rows

ID	Date
1	01/05/2020
3	13/04/2019
8	15/06/2019
9	16/08/2020

Both tables are connected as one-to-many   Table2-MainTable

Based on that criteria I'm showing a bar chart with number of blank Dates, counting MainTable(ID), Axis MainTable(Country), having in filter Table2(Date) = (Blank)

How to count percentage of blanks, having in denominator a number of rows from MainTable? (4/12 = 33%)

Thank you in advance for your support on this.

[amitchandak]

@Dan_Wis , Try measures like

M1 = count(Table2[Date])

Blank Dates = sumx(values(Table[ID]), if(isblank(M1]), 1,0))

[Dan_Wis · Accepted solution]

@amitchandak  I've just found a way:

M1 = 1-DIVIDE(CALCULATE(COUNTROWS(Table),ISBLANK('Table2'[Date])),COUNTROWS(Table))

thanks!

[Dan_Wis]

THanks @amitchandak!  this is giving me a 0, as there are no blanks in table 2.

Also I would need to use other filters - seems M1 measure is not allowing to apply filters.