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

ajaybabuinturi's avatar
ajaybabuinturi
Super User
1 year ago

Hi vincenttys,

Wanted to let you know that you can use below measure to achive your requirement.

% Delivered = 
VAR TotalWeeks = CALCULATE( DISTINCTCOUNT('YourTable'[Date]),
                            REMOVEFILTERS('YourTable'[Vendor])  -- count across all vendors
                           )
VAR DeliveredCount = SUM('YourTable'[Delivered])
RETURN
DIVIDE(DeliveredCount, TotalWeeks)

Matrix Chart Field Details

 

  • Rows: Vendor

  • Columns: WeekEnd Date

  • Values:

    • Delivered (as is)

    • % Delivered (the above DAX measure)

 

 

Thanks,
If you found this solution helpful, please consider giving it a Like👍 and marking it as Accepted Solution✔. This helps improve visibility for others who may be encountering/facing same questions/issues.

vincenttys's avatar
vincenttys
Helper I
1 year ago

Hi ajaybabuinturi 

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