Forum Discussion
Solution Specialisthow to exclude filter in KPI
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.
Super Userabc_777 ,
Try like
calculate([KPI3], removefilters(Date))
or
calculate([KPI3], removefilters(Date[Date]))
Solution Specialistwhen 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