Forum Discussion
Solved
ALL() & The error "COUNT function only accepts a column reference as an argument."
Newbie here, I receive this error message when trying to use the ALL() function in following statement. The COUNT function only accepts a column reference as an argument. Measure = count(all...
Thank you so much for the help. Although I chose to use COUNTX, your reply guided me there. The solution that that worked.
DIVIDE(COUNTX('WORK ORDERS','WORK ORDERS'[WO#]),COUNTX(ALL('WORK ORDERS'),'WORK ORDERS'[WO#]))
Ashish_Mathur
Super User
Super UserHi,
Replace COUNT with COUNTROWS.
Hope this helps.
Thank you so much for the help. Although I chose to use COUNTX, your reply guided me there. The solution that that worked.
DIVIDE(COUNTX('WORK ORDERS','WORK ORDERS'[WO#]),COUNTX(ALL('WORK ORDERS'),'WORK ORDERS'[WO#]))- Ashish_Mathur
You are welcome.