Forum Discussion
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 meaning when date select two kpi wil change value accodring but one will not
please assist
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.
26 Replies
- amitchandak
Super User
abc_777 ,
Try like
calculate([KPI3], removefilters(Date))
or
calculate([KPI3], removefilters(Date[Date]))
abc_777when i do your suggession my KPI shows the maximum.
amitchandak if you please explain more that would be great
what i want is I have KPI card show total number of total employee
and other two KPI show their monthly salary and average salary.
and I want to keep filter on to emploeyye monthly salary and average salary but dont want filter on number of Employee
this is just an example. in qlik sense they can do via $ and 1 so same thing want to power BI
thanks
ryan_mayumaybe 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.