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.
Hi geniuss!!!
I'm trying to create a measure that I'll be using against a calendar table to plot number of active contacts at any given time, but I'm tearing my hair our with some of these measures...
In simple terms, I'm trying to create a measure, that will count the number of our members, at any given time, who have a qualification date of greater than or qual to *Date*
AND a leave date that is blank OR less than or equal to *Date*.
Its the 2nd part that I'm having trouble with. So far I've got to:
Solved! Go to Solution.
Hi @Anonymous
You may try
Members TEST =
VAR CurrentDate =
MAX ( '-Calendar'[Date] )
RETURN
CALCULATE (
DISTINCTCOUNT ( 'CE vwContact (2)'[Rics_contactno] ),
'CE vwContact (2)'[Rics_ElectionDate] >= CurrentDate,
OR (
'CE vwContact (2)'[Rics_LapsedDate] <= CurrentDate,
'CE vwContact (2)'[Rics_LapsedDate] = BLANK ()
)
)
Awesome! That works, I'm going to have to play around with getting the visualisation of active members by date but the measure works, I just had to change the Or to an AND, but its accepted in which is great.
Thank you!!
Hi @Anonymous
You may try
Members TEST =
VAR CurrentDate =
MAX ( '-Calendar'[Date] )
RETURN
CALCULATE (
DISTINCTCOUNT ( 'CE vwContact (2)'[Rics_contactno] ),
'CE vwContact (2)'[Rics_ElectionDate] >= CurrentDate,
OR (
'CE vwContact (2)'[Rics_LapsedDate] <= CurrentDate,
'CE vwContact (2)'[Rics_LapsedDate] = BLANK ()
)
)
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 | |
53 | |
46 | |
15 | |
12 |