Show % of agents exceeded target in Graph Weekly and Daily

[Sri_phani]

Hello, 

I have to show the % of agents exceeded the target >55. The dataset consists of agent's day wise NPS score and out of which I have created a measure to calculate the score - Divide(Total score, Number of survey received). Now I have to show the number of agents exceeded score more than 55% on weekly and daily basis. 

I tried the below DAX  

COUNTAX(FILTER(TABLE_NAME,'TRUE/FALSE COLUMN'=TRUE()),'TRUE/FALSE COLUMN') - using True or False helper column.  

CALCULATE(DISTINCTCOUNT(Agent column, FILTER('TABLE', 'TABLE'[Score]>=0.55))

Both of them are showing the wrong number. While the helper column which is created using IF function is showing correctly week over week when added to table to see if score exceeded the target. 

Help me with a solution for getting the % of agents exceeded the target. 

Graph looking for - True/(True+False): 

[Sri_phani]

Thank you for your response. You helped me a lot.

I have used Score measure which I created inside the Calculate function and I got the result. Thank you once again.  

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file whether it suits your requirement.

exceed target agent count per week: =
DIVIDE (
    COUNTROWS (
        FILTER (
            SUMMARIZE ( data, data[agent] ),
            CALCULATE ( SUM ( data[score] ) ) >= 0.55
        )
    ),
    COUNTROWS ( SUMMARIZE ( data, data[agent] ) )
)