https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Two-Tables/m-p/3868620#M151129 <P>Post some sample data and show what the desired result is.</P> <P>You should state whether you are creating a measure or a calculated column</P> Thu, 25 Apr 2024 13:59:23 GMT HotChilli 2024-04-25T13:59:23Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Two-Tables/m-p/3868472#M151124 <P>I have two tables and I need a dax formula to get the percentage. I started with this, but it isn't working:</P><P>&nbsp;</P><P><SPAN>Percentage_Riders = VAR Riders_TODD = CALCULATE(SUM(tblFixed Category[Riders]), tblFixed Category[Category] = "TODD") VAR Riders_TODDS = CALCULATE(SUM(tblFixed Category[Riders]), tblFixed Category[Category] = "TODDS") RETURN DIVIDE(Riders_TODD, Riders_TODDS)</SPAN></P> Thu, 25 Apr 2024 13:06:41 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Two-Tables/m-p/3868472#M151124 kcummings 2024-04-25T13:06:41Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Two-Tables/m-p/3868620#M151129 <P>Post some sample data and show what the desired result is.</P> <P>You should state whether you are creating a measure or a calculated column</P> Thu, 25 Apr 2024 13:59:23 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Two-Tables/m-p/3868620#M151129 HotChilli 2024-04-25T13:59:23Z