Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Folks,
Below is the matric visual, one column contanits Efforts and other one is Avergae of sprint numbers.
when i added those two columns into Values section, I am getting below output as per below image.
But i dont want to add subtotals for averageof sprint link(X) one in below image. i need to display Totals only.
Any experts please help me here.
Thanks in advance !!
Solved! Go to Solution.
Hey @Samba777,
So you only want to show the measure for the total, i.e. when the sprint is not in scope. You can use the ISINSCOPE function for this. Try someting like this:
Measure =
IF ( NOT ISINSCOPE ( 'Table'[Sprint] ), [AverageofLast5sprint] )
It works Perfectly !! thanks
User | Count |
---|---|
98 | |
90 | |
84 | |
70 | |
67 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |