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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
sakuragihana
Helper IV
Helper IV

How to create a filtered table from a big table by using dax

Hello everyone, 

I am having a trouble creating a filtered table from one big table.

In my big file, I have many columns of data, but I just would like to create a new table with below 5 columns using DAX.

What is the right DAX expression to achieve this?

 

Base on this table : 

sakuragihana_0-1676000264138.png

 

I would like to create a table with columns : 

sakuragihana_1-1676000440841.png

I post a power bi in this link : https://drive.google.com/file/d/1UesJHvDfm-YZEOaJqlYDfCjm5oaJpKiC/view?usp=share_link 

Please help me !

 

1 ACCEPTED SOLUTION

How about this one ?😅

Power BI Desktop.png

View solution in original post

15 REPLIES 15
vannda21
Helper I
Helper I

Hi, hope this can help you

Calculated Table = SELECTCOLUMNS('Bonus data', "Group",'Bonus data'[Group], "Type",'Bonus data'[Type], "Area Target Pct", 'Bonus data'[Area Target Pct], "Min", 'Bonus data'[Min], "Max", 'Bonus data'[Max], "Bonus 1", 'Bonus data'[Bonus 1])

Hi @vannda21 ,

 The dax is not working !!

Power bi dk.png

 I use your file and it's working fine.

Hi @vannda21 , 

I would like to create a table with columns : (just 5 rows and type New Enrollment)

 

sakuragihana_0-1676003518569.png

 

Hi , I think you want to filter it by row not column if want to filter by row then let use this function

Calculated Table = FILTER('Tabel name', Place your condition here)

I think you already have your condition to get those 5 rows, so just place your condition

Hi @vannda21 ,

I use it but it is not working 

 

tbl_bonus1 =
        SUMMARIZE(
            FILTER(
            'Bonus data',
             AND('Bonus data'[Type]="NEW ENROLLMENT", 'Bonus data'[Area Target Pct]=80)
            ),
            'Bonus data'[Area Target Pct],
            'Bonus data'[Group],  
            'Bonus data'[Min],
            'Bonus data'[Max],
            'Bonus data'[Bonus 1]
        )
 
Can you fix it to me ?

Don't use SUMMARIZE, SUMMARIZE is use for grouping, just use the FILTER function only.

I use only filter and it is not working 

I followed your condition , so DAX script should be like this 2023-02-10 13_29_50-Bonus data - Power BI Desktop.png

sakuragihana_0-1676011017159.png

I try it,  but it not working 

Can you fix the dax like as : 

sakuragihana_1-1676011109646.png

 

Are you calculating a new table or a new column?
cuz what I show you is calculating new table

 

I want to create a new table from a big table by using dax

A table like as :

sakuragihana_1-1676011382003.png

Can you sent me a file power BI ?

 

 

Hi @vannda21 , 

This is not a table as I want 

A table like as :

sakuragihana_0-1676012412868.png

 

How about this one ?😅

Power BI Desktop.png

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.