Forum Discussion

vincenttys's avatar
vincenttys
Helper I
1 year ago
Solved

Calculate Percentage

Hi all, I am trying to achieve the outcome shown in the table below using Power BI. However, I'm having trouble calculating the % of delivered, which should be the sum of Delivered divided by the nu...
Need Help
  • vincenttys's avatar
    vincenttys
    1 year ago

    Hi all,

    Apologies for the delayed reply—I've been flat out with work.

    Thank you again for looking into my question. While I appreciate the suggested solutions, they didn’t quite meet my requirements. I ended up creating another visual to show the overall YTD percentage.

    Thanks again for your support.

    Best regards,
    Vince

pankajnamekar25's avatar
pankajnamekar25
Super User
1 year ago

Hello vincenttys 

 

try this measure

% Delivered =

VAR DeliveredCount = SUM('YourTable'[Delivered])

VAR WeekCount = CALCULATE(

    DISTINCTCOUNT('YourTable'[WeekEnd]),

    ALLSELECTED('YourTable'[WeekEnd])

)

RETURN

DIVIDE(DeliveredCount, WeekCount)

 

Thanks,
 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

vincenttys's avatar
vincenttys
Helper I
1 year ago

Hi pankajnamekar25 

Thanks for getting back to me so quickly.

I’d like to display only the % Delivered as a single column. Currently, I’m showing Week 1 with both Delivered and % Delivered, followed by Week 2 with the same format, and so on.

I hope that makes sense—please let me know if you need clarification.

Thank you

Regards

Vince