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.
Hello everybody,
I'm trying to create new table which will contain only non-blank distinct values of 1 column.
I tried expression bellow, but I'm still getting blank rows.
Table = CALCULATETABLE( DISTINCT( ALLNOBLANKROW(data[part_number])))
I was also trying adding filter, but with same result 😕
Table = CALCULATETABLE( DISTINCT( ALLNOBLANKROW(data[part_number]));
FILTER( ALL(data[part_number]);
ISBLANK(data[part_number])=FALSE()
))
I'm trying to create new table which will contain only non-blank distinct values of 1 column.
I tried expression bellow, but I'm still getting blank rows.
Thanks for any help.
Zuzana
Solved! Go to Solution.
HI @Anonymous,
You can try to use below formula to filter the blank records.
Distinct = CALCULATETABLE(VALUES('Sample Table'[Text]),LEN('Sample Table'[Text])>0,'Sample Table'[Text]<>" ")
In addition, I also test with these functions, but it seems like 'allnoblankrow' and 'isblank' function not works.
Regards,
Xiaoxin Sheng
HI @Anonymous,
You can try to use below formula to filter the blank records.
Distinct = CALCULATETABLE(VALUES('Sample Table'[Text]),LEN('Sample Table'[Text])>0,'Sample Table'[Text]<>" ")
In addition, I also test with these functions, but it seems like 'allnoblankrow' and 'isblank' function not works.
Regards,
Xiaoxin Sheng
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 |