Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all. Me again.... I've been struggling with a measure formula for a few days building on from the last one.
I've looked at a few posts with similar problems but can't seem to sort the formula....
I'm trying to count using a measure, active contacts of a specific grade.
My active contacts measure (that works) is:
Solved! Go to Solution.
@Anonymous you mean you want the grade to be 200000001 OR 200000002? I assume it cannot be both at the same time ...
Also, the first argument of FILTER needs to be a table and you are passing a column.
Second, you are not using the AND operator correctly.
Anyway, you don't need to user the FILTER statement in that case. Maybe this will do :
My_Measure =
CALCULATE(
DISTINCTCOUNT('CE vwContact'[Rics_contactno]),
'CE vwContact'[Rics_LapsedDate]<=TODAY(),
'CE vwContact'[Rics_MemberGrade] IN {'200000001','200000002'}
)
Thank you so much! That sorted it. The only thing I had to chance was putting " instead of ' around the 200000001 numbers. Thank you!!
@Anonymous you mean you want the grade to be 200000001 OR 200000002? I assume it cannot be both at the same time ...
Also, the first argument of FILTER needs to be a table and you are passing a column.
Second, you are not using the AND operator correctly.
Anyway, you don't need to user the FILTER statement in that case. Maybe this will do :
My_Measure =
CALCULATE(
DISTINCTCOUNT('CE vwContact'[Rics_contactno]),
'CE vwContact'[Rics_LapsedDate]<=TODAY(),
'CE vwContact'[Rics_MemberGrade] IN {'200000001','200000002'}
)
User | Count |
---|---|
50 | |
25 | |
18 | |
17 | |
14 |
User | Count |
---|---|
91 | |
86 | |
39 | |
25 | |
21 |