Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to Solution.
@amitchandak I've just found a way:
@Dan_Wis , Try measures like
M1 = count(Table2[Date])
Blank Dates = sumx(values(Table[ID]), if(isblank(M1]), 1,0))
@amitchandak I've just found a way:
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.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |