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.
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
Super Userthe KPI will not be affected by the filters. Then you need to write the correct DAX to show your value or use visual filter to fix the filter selection.
- abc_777
eazy reply. but need more clearity. anyways is there anyone can give more clear ans please
- ryan_mayu
it's very difficult to provide detailed answer, unless you can provide sample data and expected output.
- abc_777
here are 3 KPI among them first one January 2021 total customer need to be static and newly monthly customer and Newly daily cusotmer would change as per filter or slicer.
there would be no effect to Total january customer.
I have tried Edit Intraction under format Menu but when i click None its not working (it shows total of value from beginning to today total customer) thats not I want.