Forum Discussion
Two Tables
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)
1 Reply
Post some sample data and show what the desired result is.
You should state whether you are creating a measure or a calculated column
