Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello, I just have a quick question.
So, we have a table called "Not_messaged' that has information about candidates. These fields are lastMessageDate (Date field), id (integer field), NotesMessageDate (Date field), and CallNotesLogDate (Date field).
what we want is to return a distinct count of ids that:
Do NOT have messagedLastSentDate before today's date
OR DOES NOT have callNotesLogdate = todays date
OR DOES NOT have NotesLogDate = today's date
I am trying to come up with a DAX expression that can return a distinct count of the ids. However, we are getting stuck because we're not good at DAX expressions.
Solved! Go to Solution.
You can put as many conditions as you want in a FILTER.
CALCULATE (
DISTINCTCOUNT ( Not_messaged[id] ),
FILTER (
Not_messaged,
Not_messaged[lastMessageDate] >= TODAY ()
|| Not_messaged[callNotesLogdate] <> TODAY ()
|| Not_messaged[NotesLogDate] <> TODAY ()
)
)
You can put as many conditions as you want in a FILTER.
CALCULATE (
DISTINCTCOUNT ( Not_messaged[id] ),
FILTER (
Not_messaged,
Not_messaged[lastMessageDate] >= TODAY ()
|| Not_messaged[callNotesLogdate] <> TODAY ()
|| Not_messaged[NotesLogDate] <> TODAY ()
)
)
Seems like you just don't want today's date. You can add a date filter to the visual (or page/report)! Attached is an example of a date filter using the relative date filter type.
@Anonymous please provide sample data and desired output.
I'd use the distinctcount function for DAX and then just use visual level filters to achieve what you're looking for
So something similar to
DISTINCTCOUNT('Not_messaged'[id])
I see, for the visual filters, can you do IF/OR statements?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
46 | |
28 | |
22 | |
12 | |
8 |
User | Count |
---|---|
75 | |
52 | |
46 | |
15 | |
12 |