Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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?

Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi Anonymous,

     

    You could modify your KPI Target measure similar to:

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

     

    Regards,

    Yuliana Gu

1 Reply

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    Hi Anonymous,

     

    You could modify your KPI Target measure similar to:

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

     

    Regards,

    Yuliana Gu