Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I have gone through below and understood what Keepfilter does however I am not sure what is the use case of Keepfilter, in which scenario we should use keepfilter function
https://www.youtube.com/watch?v=M-a7sgpHaFE&pp=ygUKa2VlcGZpbHRlcg%3D%3D
Solved! Go to Solution.
A very basic example here, lets say I want to show all Non lockdown years.
So I apply a filter says DO NOT return 2020 and 2021 data.
The issue is DAX removes the existing year filters and then applies my NOT filter.
Each column is returning the TOTAL of all years NOT 2020, 2021.
Clearly what I meant was, keep the original year filters and don't show data for 2020 and 2021.
So I tell it to keep the table to keep the original filters.
If you are happy with this answer please mark as a solution for others to find !
Kudos are always appreciated! Check out our free Power BI video courses.
A very basic example here, lets say I want to show all Non lockdown years.
So I apply a filter says DO NOT return 2020 and 2021 data.
The issue is DAX removes the existing year filters and then applies my NOT filter.
Each column is returning the TOTAL of all years NOT 2020, 2021.
Clearly what I meant was, keep the original year filters and don't show data for 2020 and 2021.
So I tell it to keep the table to keep the original filters.
If you are happy with this answer please mark as a solution for others to find !
Kudos are always appreciated! Check out our free Power BI video courses.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 38 | |
| 36 | |
| 33 | |
| 32 | |
| 28 |
| User | Count |
|---|---|
| 129 | |
| 88 | |
| 79 | |
| 68 | |
| 63 |