How to get the percentage using the DIVIDE function in Power BI

[shaikhzdandg]

I have a requirement to show a Percentage by Name in Power BI. What I need is shown in Column named (Category Type 2%)

I have done below in excel not quite getting the same result in Power BI

[shaikhzdandg]

super, looks like its working Excellent and Many Thanks @PijushRoy 

[PijushRoy]

@shaikhzdandg You are welcome

[PijushRoy · Accepted solution]

Hi @shaikhzdandg 

Please find the DAX

Category 2 % = 
DIVIDE(
    SUM('Table'[Total Rows]),
    CALCULATE(SUM('Table'[Total Rows]),ALL('Table'[Name])),
    0)

There are two rows with same AN name

Accept as Solution if resolved your question