gino59
Active Member
- Joined
- Jul 26, 2010
- Messages
- 496
Hi all,
I'm trying to create a measure to calculate the average pass rate. If the value in the [Grade] column is equal to "pass", then divide the total count of "pass" by the total count in [Grade]. Seems straight forward enough, but I've only recently begun to dabble in DAX and am probably overthinking this.
The formula I used is:
=if(Table1[Grade]="pass",countax(Table1,Table1[Grade])/countax(all(Table1),Table1[Grade]),"")
The error message says the value for column "Grade" in Table1 cannot be determined in the current context. Check that all columns referenced in the calcualtione exist, and that there are no circular dependencies.
The data in the column is complete (no missing values), so I'm not sure where the circular dependencies might be or what the real error is.
Any suggestions?
Many many thanks!
Gino
I'm trying to create a measure to calculate the average pass rate. If the value in the [Grade] column is equal to "pass", then divide the total count of "pass" by the total count in [Grade]. Seems straight forward enough, but I've only recently begun to dabble in DAX and am probably overthinking this.
The formula I used is:
=if(Table1[Grade]="pass",countax(Table1,Table1[Grade])/countax(all(Table1),Table1[Grade]),"")
The error message says the value for column "Grade" in Table1 cannot be determined in the current context. Check that all columns referenced in the calcualtione exist, and that there are no circular dependencies.
The data in the column is complete (no missing values), so I'm not sure where the circular dependencies might be or what the real error is.
Any suggestions?
Many many thanks!
Gino
