cancel
Showing results for 
Search instead for 
Did you mean: 
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
Resident Rockstar
Resident Rockstar

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
Resident Rockstar
Resident Rockstar

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
Join Arun Ulag at MPPC23

Join Arun Ulag at MPPC23

Get a sneak peek into this year's Power Platform Conference Keynote.

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors