Forum Discussion
Need help with DAX
Hi All, Please help me with the below DAX. Count Var SFDC % (ODSG Vs ADP) = ([Count Diff SFDC (ODSG Vs ADP)]/VALUES(ADP_COUNT_SFDC[ODSG_Count]))*100 I'm getting infinity for this,...
Please try this instead. VALUES returns a table, so you need to aggregate it.
Count Var SFDC % (ODSG Vs ADP) = ([Count Diff SFDC (ODSG Vs ADP)]/COUNTROWS(VALUES(ADP_COUNT_SFDC[ODSG_Count])))*100
Pat