Two Tables

[kcummings]

I have two tables and I need a dax formula to get the percentage. I started with this, but it isn't working:

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)

[HotChilli]

Post some sample data and show what the desired result is.

You should state whether you are creating a measure or a calculated column