cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate II
Advocate II

table of distinct and filtered values

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 CALCULATETABLEDISTINCTALLNOBLANKROW(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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

HI @Zuzana,

 

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

1 REPLY 1
Highlighted
Community Support
Community Support

HI @Zuzana,

 

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors