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 Userit's very difficult to provide detailed answer, unless you can provide sample data and expected output.
Solution Specialisthere 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.
- abc_777
yes
Hi abc_777 ,
Could you please share some sample data(exclude sensitive data) and the Fields setting of Customer Count KPI which get total number of total employee in order to get good understand for your requirement and provide you a suitable solution? Please also provide the related formula if you apply any measure on that Customer Count KPI visual. Thank you.
In addition, please review the solution in the following thread and check whether they can help you resolve the problem.
Exclude Visual Filter in KPI for the Target
How to disable filters in Power BI
Best Regards