## Desktop

Occasional Visitor
Posts: 1
Registered: ‎01-10-2019

# Calculate % on tot into the Card Object

Hello teams,

I'd like to solve this problem. At belove, an example of my data:

The column CUT_OFF is calculated that: if(KPI_1>5;1;0).

Now my desire is to calculate the percentage value of how many suppliers exceed the threshold compared to the total considering only the separate suppliers. In this case it is equivalent to 3/4 = 66.6%

Accepted Solutions
Highlighted
Community Support Team
Posts: 5,709
Registered: ‎09-21-2016

## Re: Calculate % on tot into the Card Object

Hi @Fabio_RM86,

New below measure.

```% =
CALCULATE (
DISTINCTCOUNT ( Test1[SUPPLIER] ),
FILTER ( ALLEXCEPT ( Test1, Test1[YEAR] ), Test1[CUT_OFF] = 1 )
)
/ CALCULATE (
DISTINCTCOUNT ( Test1[SUPPLIER] ),
ALLEXCEPT ( Test1, Test1[YEAR] )
)```

Best 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.

All Replies
Highlighted
Community Support Team
Posts: 5,709
Registered: ‎09-21-2016

## Re: Calculate % on tot into the Card Object

Hi @Fabio_RM86,

New below measure.

```% =
CALCULATE (
DISTINCTCOUNT ( Test1[SUPPLIER] ),
FILTER ( ALLEXCEPT ( Test1, Test1[YEAR] ), Test1[CUT_OFF] = 1 )
)
/ CALCULATE (
DISTINCTCOUNT ( Test1[SUPPLIER] ),
ALLEXCEPT ( Test1, Test1[YEAR] )
)```

Best 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.