Forum Discussion
Filter Table to Show Rows When a Value Shows Up a Certain Amount of Times
I'm wanting to filter some data in a "query a dataset" in power automate from a power bi dataset to create a dynamic monthly report.
How can I filter data when a value type repeats a number of time? For example, if a "Code" pops up more than 2 times, I want to create a table showing only those values in an automated email.
See below for a very simple example
| Create Date | Area | Code |
| 9/5/2022 | A | 1 |
| 5/4/2022 | B | 2 |
| 6/5/2022 | A | 3 |
| 7/3/2022 | D | 1 |
| 3/4/2022 | E | 1 |
| 2/5/2022 | X | 2 |
| Create Date | Area | Code |
| 9/5/2022 | A | 1 |
| 7/3/2022 | D | 1 |
| 3/4/2022 | E | 1 |
1 Reply
- tamerj1
Community Champion
Hi Anonymous
You can place the following filter measure in the filter pane of the table visual and select "Is not blank" then apply the filter
Filter Measure = IF ( COUNTROWS ( CALCULATETABLE ( 'Table', ALLEXCEPT ( 'Table', 'Table'[Code] ) ) ) > 1, 1 )
