What kind of data does the KPI visual accept?

[Anonymous]

Hello all, 

I'm trying to create a Goal for a KPI I was asked to make. Management wants it to be "50% of annual deals entered should be won." 

I tried making the following measure, but it hit me with the "Can't Display the Visual" error.

PERCENTILEX.INC('Steph - Business Update - Houston', 'Steph - Business Update - Houston'[Stage] = "Closed Won", .5)

What can I do to make this work? Did I write the DAX correctly based on my requirements?

[v-yalanwu-msft]

Hi, @Anonymous ;

Is your problem solved? If so, Would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.

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

[v-yalanwu-msft]

Hi, @Anonymous ;

You can first look at the usage of PERCENTILEX.INC, PERCENTILEX.INC (<table>, <expression>, <k>)

Where <expression> I understand should be a number type, here 'Steph - Business Update - Houston'[Stage] = "Closed Won" This column should be a number type,however the result of the expression is true or false.

so can you share a simple data and more datails?

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

[littlemojopuppy]

Hi @Anonymous 

Your measure isn't working because you need to have something numeric to base the percentile on.

I'm assuming that the value in the KPI visual is count of deals by unit of time.  So the goal/target for the visual should be that count divided by two.  Maybe???  You're not providing a lot of detail to work with.