topic How to calculate a percentage for each line in a table based on a measure in DAX Commands and Tips
https://community.powerbi.com/t5/DAX-Commands-and-Tips/How-to-calculate-a-percentage-for-each-line-in-a-table-based-on/m-p/2135392#M49035
<P>Hi</P><P> </P><P>I would like to calculate the percentages in PBI below. This is the example of the data in Excel.</P><P>The red percentage is the blue number (the costs) divided by the revenue.</P><P>Each line has another number, and each month the revenue is different. How do I solve this?</P><P> </P><P>Thank you</P><P> </P>Wed, 20 Oct 2021 11:01:18 GMTStephanieDujard2021-10-20T11:01:18ZHow to calculate a percentage for each line in a table based on a measure
https://community.powerbi.com/t5/DAX-Commands-and-Tips/How-to-calculate-a-percentage-for-each-line-in-a-table-based-on/m-p/2135392#M49035
<P>Hi</P><P> </P><P>I would like to calculate the percentages in PBI below. This is the example of the data in Excel.</P><P>The red percentage is the blue number (the costs) divided by the revenue.</P><P>Each line has another number, and each month the revenue is different. How do I solve this?</P><P> </P><P>Thank you</P><P> </P>Wed, 20 Oct 2021 11:01:18 GMThttps://community.powerbi.com/t5/DAX-Commands-and-Tips/How-to-calculate-a-percentage-for-each-line-in-a-table-based-on/m-p/2135392#M49035StephanieDujard2021-10-20T11:01:18ZRe: How to calculate a percentage for each line in a table based on a measure
https://community.powerbi.com/t5/DAX-Commands-and-Tips/How-to-calculate-a-percentage-for-each-line-in-a-table-based-on/m-p/2138548#M49121
<P>Please provide sanitized sample data that fully covers your issue. Paste the data into a table in your post or use one of the file services. Please show the expected outcome.</P>Sat, 16 Oct 2021 22:27:39 GMThttps://community.powerbi.com/t5/DAX-Commands-and-Tips/How-to-calculate-a-percentage-for-each-line-in-a-table-based-on/m-p/2138548#M49121lbendlin2021-10-16T22:27:39Z