Forum Discussion
abc_777
Solution Specialist
Solution Specialisthow to exclude filter in KPI
Dear Concern, In power bi I have 3 KPI. they all changes when i select any date but I want to keeep filter option in two KPI and another KPI one I just dont want to change filter value. SO meani...
abc_777 ,
Try like
calculate([KPI3], removefilters(Date))
or
calculate([KPI3], removefilters(Date[Date]))
maybe you can try to change visual interactions
https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions
Over-all Employees =
COUNTX(
ALL(Table_Name),
Table_Name[Employee_Name]
)
//The ALL function shields this KPI from other slicer filters and other context filters.
ryan_mayu
Super User
Super Usermaybe you can try to change visual interactions
https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions