Forum Discussion

LearnToFly's avatar
LearnToFly
Frequent Visitor
2 years ago
Solved

Not sure how to rewrite...

TransferDate = VAR DeptMatch = --If the transaction date column is not blank, this counts the number of  matches it has between departments     CALCULATE(         COUNTROWS(FILTER('ICS_PhoneExt_...
Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

    Replace 

    'ICS_PhoneExt_8x8'[8E_Ext] = VALUES('Call Detail Record'[AA_Destination])

    with

    'ICS_PhoneExt_8x8'[8E_Ext] IN VALUES('Call Detail Record'[AA_Destination])
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Replace 

'ICS_PhoneExt_8x8'[8E_Ext] = VALUES('Call Detail Record'[AA_Destination])

with

'ICS_PhoneExt_8x8'[8E_Ext] IN VALUES('Call Detail Record'[AA_Destination])