Forum Discussion
Solved
DAX - Exclude a specific filter in a specific column, but keep all others
Hi all, I have the following DAX measure: test = CALCULATE(
COUNTROWS(ma_out_full),
FILTER(ALL(ma_out_full), ma_out_full[Update Timestamp] = "As of Jul 31, 2023")
ALLEXCEPT ( ...
oh my bad instead of , use &&
test = CALCULATE( COUNTROWS(ma_out_full), FILTER(ALL(ma_out_full), ma_out_full[Update Timestamp] = "As of Jul 31, 2023" && ma_out_full[Transfer Status] <> "Case Closed") )
eliasayyy
Memorable Member
Memorable Member
test = CALCULATE(
COUNTROWS(ma_out_full),
FILTER(ALL(ma_out_full), ma_out_full[Update Timestamp] = "As of Jul 31, 2023",ma_out_full[Transfer Status] <> "Case Closed")
)
to help you better understand
all means remove filter from all the table
allexcept means remove filter from all the table except a specified column
allselected means removefilter from all columns selected
Thanks annonymous1999 for the prompt reply!
Unfortunately, when I tried running your code, I got a message saying "Too many arguments were passed for the FILTER function. The maximum argument count for the function is 2". So I tried adding an extra pair of paranthesis to see if that would fix the issue, but it didn't.
Hope this isn't a version issue.
Thanks again.
