I have a dynamic switch statement that (so far) currently identifies the column as I would like. and based on a duedate column. (not sure if it's as elegant) What I would like to do (maybe it's not possible using a measure per say) is dynamically count the total for each flag/or grouping (past due, closed, due tomorrow, due today, no due date...etc.) so that the user can see a count in a card format? I suppose the better method is to just tag my data the same way in a calculated column, which would make it easier to count i suppose. Anyway, just wondering.
VAR DaysFromExpiry =
VAR Switch =
vDaysFromExpiry < 0, "🚩 Past Due",
vDaysFromExpiry = 0, "🕗 Due Today!",
vDaysFromExpiry <= 1, "🕗 Due Tomorrow!",
"📆 Future Date"
MAX('table'[DateClosed]) <> BLANK (), "✔️ Closed",
MAX('table'[SubmissionDueDate]) = BLANK(), "🔔 No Due Date",
Essentially, I pull that measure over to a table, and i get something like this (and what i want to do is dynamincally count these groups out side of the table view):