Don't miss your chance to take the Fabric Data Engineer (DP-700) exam on us!
Learn moreWe've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now
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.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 55 | |
| 34 | |
| 32 | |
| 19 | |
| 17 |
| User | Count |
|---|---|
| 75 | |
| 72 | |
| 38 | |
| 35 | |
| 25 |