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 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'}
)
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 |
---|---|
44 | |
28 | |
21 | |
12 | |
8 |
User | Count |
---|---|
74 | |
51 | |
45 | |
16 | |
12 |