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.
I have a table of 15 rows with two columns (A+B), where A has values from zero to five (3 rows zero and 7 rows with values=10 rows) but also some blank values (5 rows). I want to create a new table where I filter out only blanks, but including 0-5 using:
I added a column in the original table:
CheckNumberOfNoBlanks =
CALCULATE (
COUNTA ( Sheet1[A] ),
FILTER (Sheet1, Sheet1[A] <> BLANK () || Sheet1[A] = 0)
)
which gives me the correct number of NoBlanks (10 rows) but for some reason this does not work when creating the Table?
Any help to get me out of confusing state...
Solved! Go to Solution.
use
if(isblank(column), "value if blank", "value if not blank")
Proud to be a Super User!
use
if(isblank(column), "value if blank", "value if not blank")
Proud to be a Super User!
Thanks, but is there a way to do this without creating a extra column in the original table? I have a number of these to filter out...
....and yes there is:
Table = Filter(Sheet1, if(ISBLANK(Sheet1[A]), FALSE(), TRUE()))
Thanks for your help!
@Frost ok so just so understand what you trying to do, you trying to create a new table based on the condition that nothing is blank?
how are you creating the new table?
Proud to be a Super User!
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 |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |