Forum Discussion
user story and task rollups
Not sure if this is the right forum, but here is the issue: I am tryin to create a sioimple report which shows all client costs (charges) to date. I am using one view table from TFS_Warehouse (on-prem TFS) and anotehr table which has the resource info (name, rate, etc.). I have created a measure which calculates the cost based on the rate and completed work at task level. Now I need to show the rollups to the uer story level where the client is tagged. Is there a way to use DAX, or another means, to associate the user stories with the child tasks so I can make that calculation? Any help would be appreciated.
7 Replies
- v-jiascu-msft
Microsoft Employee
Hi spsalter,
Yeah, you are in the right place. But we can't write out a dax formula without data model. Can you please provide a sample .pbix file?
Best Regards!
Dale
- spsalterRegular Visitor
what is the best way to send over pbix? Seems I can only upoad photo files.
- v-jiascu-msft
Microsoft Employee
Hi spsalter,
If you can send it publicly, you can upload your file into GoogleDrive, OneDrive, etc. then share the link here. Or send me the link by private message.
Best Regards!
Dale