Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
lgs1983
Helper I
Helper I

Calculated Table with Filter, showing specific columns

Hi,

 

I'm trying to create a calculated table where all those that have failed data validation end up.

 

The data validation is done in the table so I need to filter on the column in there when it equals 1. My only issue now is only bringing back certain columns into that calculated table as only a few are required.

Table = FILTER(AllTagExtracts, AllTagExtracts[ExtractDUNS Equals ERDDUNS Ind]=1)

As always, any help is appreciated.

1 ACCEPTED SOLUTION
AnkitBI
Solution Sage
Solution Sage

Use SelectColumn like

 

Table 2 = SELECTCOLUMNS(filter(Data,Data[Salary1] > 10),"Department",Data[Department],"Salary",Data[Salary1])

Thanks
Ankit Jain

Do Mark it as solution if the response resolved your problem. Do like the response if it seems good and helpful.

View solution in original post

2 REPLIES 2
AnkitBI
Solution Sage
Solution Sage

Use SelectColumn like

 

Table 2 = SELECTCOLUMNS(filter(Data,Data[Salary1] > 10),"Department",Data[Department],"Salary",Data[Salary1])

Thanks
Ankit Jain

Do Mark it as solution if the response resolved your problem. Do like the response if it seems good and helpful.

That's how SELECTCOLUMNS works. Was one of the functions I was looking at but didn't know was a custom name you had to provide for the column header. Thanks very much @AnkitBI 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.