Forum Discussion
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...
JNelson , a measure like
calculate([Actual Amount], filter(Account, not Account[ID] in { 84900, 84901, 84905}))
Fy to filter and added additional
JNelson , a measure like
calculate([Actual Amount], filter(Account, not Account[ID] in { 84900, 84901, 84905}))
Fy to filter and added additional
Ah!! Thank you so much! Worked like a charm. 🙂