Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
singleton2787
Helper III
Helper III

Something I'm missing percentage almost working now

I want to calc the percentage based on the blue, green and yellow highlighted items. By row and by column

 

Percentage of Work =
DIVIDE(
SUM('Features'[Sum Feature TagNames]),
COUNTA('Stories'[WorkItemId])
)

 

singleton2787_1-1669991425069.png

 

 

1 ACCEPTED SOLUTION
djurecicK2
Super User
Super User

Hi @singleton2787 ,

 You could try adding Story WorkItemID to the visual again, then show value as Percent of grand total.

 

djurecicK2_0-1669992519833.png

 

 

View solution in original post

2 REPLIES 2
singleton2787
Helper III
Helper III

@djurecicK2 ... well shoot! Here I was getting all fancy and over-engineering it 🙂 Thanks!

djurecicK2
Super User
Super User

Hi @singleton2787 ,

 You could try adding Story WorkItemID to the visual again, then show value as Percent of grand total.

 

djurecicK2_0-1669992519833.png

 

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.