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 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.
Solution Specialisteazy 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.