Forum Discussion

JNelson's avatar
JNelson
Icon for Helper II rankHelper II
4 years ago
Solved

Measure to exclude certain rows

Hello! I have an direct query file I'm working with which is very security restricted (eg. I cannot create new tables/columns etc).    I've created a matrix that pulls through a grand total of all...
  • amitchandak's avatar
    amitchandak
    4 years ago

    JNelson , a measure like

    calculate([Actual Amount], filter(Account, not Account[ID] in { 84900, 84901, 84905}))

     

    Fy to filter and added additional

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

JNelson , a measure like

calculate([Actual Amount], filter(Account, not Account[ID] in { 84900, 84901, 84905}))

 

Fy to filter and added additional

JNelson's avatar
JNelson
Icon for Helper II rankHelper II
4 years ago

Ah!! Thank you so much! Worked like a charm. ðŸ™‚