Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
You can use the Line and stacked bar chart , use the average as the line.
Do you think this works for you?
Thanks
Raj
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
@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
User | Count |
---|---|
101 | |
90 | |
78 | |
70 | |
69 |
User | Count |
---|---|
110 | |
96 | |
95 | |
74 | |
71 |