cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Exclude Visual Filter in KPI for the Target

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?

1 ACCEPTED SOLUTION

Accepted Solutions
v-yulgu-msft Super Contributor
Super Contributor

Re: Exclude Visual Filter in KPI for the Target

Hi @Anonymous,

 

You could modify your KPI Target measure similar to:

Target=CALCULATE(COUNT(Total Visit[Visit]),ALL(Total Visit))

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
v-yulgu-msft Super Contributor
Super Contributor

Re: Exclude Visual Filter in KPI for the Target

Hi @Anonymous,

 

You could modify your KPI Target measure similar to:

Target=CALCULATE(COUNT(Total Visit[Visit]),ALL(Total Visit))

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 40 members 941 guests
Please welcome our newest community members: