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

RicoZhou's avatar
RicoZhou
Frequent Visitor
1 year ago

Hi vincenttys ,

 

I think you can show % of delivery in subtotal position.

You can try measure as below.

Measure = 
VAR _Count = CALCULATE(COUNT('Table'[Weekend]),FILTER('Table','Table'[Value] = 1))+0
VAR _Total = CALCULATE(COUNT('Table'[Weekend]))
RETURN
IF( HASONEVALUE('Table'[Weekend]),_Count, FORMAT(DIVIDE(_Count,_Total),"0.0%"))

Result is as below.

 

Best Regards,

Rico Zhou

 

vincenttys's avatar
vincenttys
Helper I
1 year ago

Hi RicoZhou ,

Are you able to give me more guidance as i am pretty new to this?

Currently, i have huge table that contain the data which have week ending for each records and whether it is delivered - that column will show 1 if delivered and 0 otherwise.

Example Week 1, i have 3 vendors A, B and C and in Week 1

Vendor A have 3 delivered, Vendor B have 0 delivered and Vendor C have 2 delivered.

My measure will have "delivered count" which is the average as i just want to show 1 and 0 for the week for either delivered or not.

The next step is i will have a matrix table with vendor in rows and week ending for current FY in columns as my original post stated.

Now i want to add % delivered for current FY. 

I think your idea of showing % of delivery in subtotal position is what i want but i am not sure how to get there.

Thanks again for helping.

Regards,

Vince