Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
User | Count |
---|---|
120 | |
72 | |
69 | |
57 | |
50 |
User | Count |
---|---|
167 | |
82 | |
68 | |
65 | |
53 |