Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |