I would like to exclude a visual filter for my KPI Target measure
In a KPI visual I have a Count of "Visit" with a basic filter on column"reason visit" "relation". Both are in the "Total visit" table.
Now I would like to add a target, which counts the total of "Visit" without filtering the "relation"
Can anyone tell me how to do this?
Go to Solution.
You could modify your KPI Target measure similar to:
Target=CALCULATE(COUNT(Total Visit[Visit]),ALL(Total Visit))
Power BI Super User, Greg Deckler, explains
Register by September 5 to save $200
Engage and empower students with Power BI!
Continue your learning in our online communities.