Velocity Formula

[amit_wairkar]

Hi,

I have written a formula to calculate the Velocity. I could use it to show in plotting the Actual v/s Planned Sprints but not able to display the same using Card. Below is my formula:

Velocity = AVERAGEX(CALCULATETABLE('Agile Projects Sprints',

NOT(ISBLANK('Agile Projects Sprints'[Sprint])), 'Agile Projects WorkItems'[Sprint State] <> "Active", CROSSFILTER('Agile Projects Sprints'[Iteration Path], 'Agile Projects WorkItems'[Iteration Path], Both)),

var p = [Actual Story Points] return if (ISBLANK(p),0,p))

Let me know how to display the same in Cards.

Regards,

Amit Wairkar

[v-venuppu]

Hi @amit_wairkar ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-venuppu]

Hi @amit_wairkar ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-venuppu]

Hi @amit_wairkar ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @bhanu_gautam for the prompt response.

I tried implementing it with sample data in Card visual, but it worked for me.

Please find attached pbix file for your reference.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

 Thank you.

 

[amit_wairkar]

Hi Bhanu,

I meant that when i m trying it do display in a line graph for each sprints, it shows the value. But when i am using the Card visualization, it is showing Zero.

Regards,

Amit  Wairkar

[bhanu_gautam]

@amit_wairkar 

Open your Power BI report.
Go to the "Visualizations" pane and select the "Card" visualization.
Drag and drop your newly created measure (Velocity) into the "Values" field of the Card visualization.
Adjust the Card Settings:

You can format the Card visualization to display the Velocity measure as you prefer. This includes adjusting the font size, color, and other visual properties to make it more readable and visually appealing.