Isolate the total of a measure

[JulienReny]

Hi community,

I've been trying for a while now and still didn't found a solution.

is it possible to isolate the Total of a measure in a Target Table so i can use it as a Goal line in a bar chart like i did with Taux cible 65% ?

The difference is that Taux cible is a hard data.

Thanks in advance

[Anonymous]

You can use the Line and stacked bar chart , use the average as the line.

Do you think this works for you?

Thanks
Raj

[JulienReny]

Hi rajendran,

The problem is that I cannot do an average on a measure. 

Here's how i built Taux de succès:

conclu count = SUM(CRM_GRI_Opportunity_Fr[Conclu])    (numreator)

count dénominateur = COUNT(CRM_GRI_Opportunity_Fr[Ne pas modifier) Opportunité]) (denominator)

Taux de succès = [conclu count]/[count dénominateur]

so again, is there a function that give the total of a measure or something so i can isolate it in a target table?

Thanks

[v-yuezhe-msft]

@JulienReny,

Do you want to create a measure that returns 67.41% and then add this measure to  Line section of your chart? If so, could you please share sample data of your original table so  that we can test?

Regards,
Lydia