Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateJoin 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.
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 :
I would like to create a table with columns :
I post a power bi in this link : https://drive.google.com/file/d/1UesJHvDfm-YZEOaJqlYDfCjm5oaJpKiC/view?usp=share_link
Please help me !
Solved! Go to Solution.
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])
I use your file and it's working fine.
Hi , I think you want to filter it by row not column if want to filter by row then let use this function
Hi @vannda21 ,
I use it but it is not working
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
I try it, but it not working
Can you fix the dax like as :
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 :
Can you sent me a file power BI ?
How about this one ?😅
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
60 | |
58 | |
56 | |
38 | |
28 |
User | Count |
---|---|
82 | |
62 | |
45 | |
41 | |
40 |