Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have treid in vain to create a new table that only has some of the rows in the original and would appreciate some help.
I have a table called 'Stuff'. It has many columns and a lot of rows. I want to create a new table called 'SomeStuff' that only has the rows who's column 'strategies' contains the phrase 'Technology-'.
I have tried using CONTAINS and IF and FILTER and have no success.
The corrext DAX would be greatly appreciated.
Solved! Go to Solution.
Hi @TPB_Paul
You can create a new Calculated Table as follows
Go to Modelling Tab>> New Table
New Table = FILTER ( ADDCOLUMNS ( stuff, "Check", FIND ( "Technology-", Stuff[Strategies],, 0 ) ), [Check] > 0 )
Also you can add a calculated Column and filter the results using this column
Column = FIND ( "Technology-", Stuff[Strategies],, 0 )
Hi @TPB_Paul
You can create a new Calculated Table as follows
Go to Modelling Tab>> New Table
New Table = FILTER ( ADDCOLUMNS ( stuff, "Check", FIND ( "Technology-", Stuff[Strategies],, 0 ) ), [Check] > 0 )
Also you can add a calculated Column and filter the results using this column
Column = FIND ( "Technology-", Stuff[Strategies],, 0 )
This was a great help for usin g the FIND. However my main problem is the fact that PowerBI does not save the settings for a filter and I need that functionality so that each department only sees their data. If I could combine FIND and FILTER I could solve the problem. If I have a column named DEPT, and out of all the departments I want to filter 'SPORTS', is there a way I could create a column that would act as a filter to only show data for the SPORTS department?
This would solve all my filtering problems until there is a way to save default filtering in a report.
Worked great. Thanks so much !!
User | Count |
---|---|
99 | |
86 | |
80 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |