Reply
Highlighted
Occasional Visitor
Posts: 1
Registered: ‎01-10-2019
Accepted Solution

Calculate % on tot into the Card Object

 

Hello teams,

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

 

Example_Data.PNG

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
Community Support Team
Posts: 5,684
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] )
    )

1.PNG

 

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.

View solution in original post


All Replies
Community Support Team
Posts: 5,684
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] )
    )

1.PNG

 

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.