CALCULATE(DISTINCTCOUNT( when using a created if measure

[RPATER]

Hi All,

I am currently trying to create a card that counts the distinct number of campaigns after two filters are applied to a large table.  The first filter is that column(wave) = 1 and the second is that a measure I created:

"Risk"

IF ( SELECTEDVALUE ( Query1[Wave] ) = 1 && [Delivery_Rate] < .85, 1, 0 )

Needs to equal 1.  The final result should be a count of 2 but I either get 19(total number of unique campaigns in the table) or the following error:

"A Function 'Calculate' has been used in a True/False expression that is used as a table filter expression. This is not allowed."

I understand that the error is coming from the "Risk" measure but I am not sure of a way around that to get my solution.  Any suggestions would help greatly!

Thank You,

Ryan

DAX attempts:

1. distinct campaigns = CALCULATE(DISTINCTCOUNT(Query1[CampaignName]),[Risk2]=1, Query1[Wave]=1)

2. distinct campaigns = CALCULATE(DISTINCTCOUNT(Query1[CampaignName]),

FILTER(query1,Query1[Wave]=1 && [Delivery_Rate]<.85))

Example data:

ClientId	CampaignName	AssetName	Risk
1	Campaign1	Asset1	1
2	Campaign2	Asset2	1
3	Campaign3	Asset3	0
4	Campaign4	Asset4	0
1	Campaign5	Asset5	0
1	Campaign6	Asset6	0
1	Campaign7	Asset7	0
1	Campaign8	Asset8	0
2	Campaign9	Asset9	0
2	Campaign10	Asset10	0
2	Campaign11	Asset11	0
2	Campaign12	Asset12	0
2	Campaign13	Asset13	0
2	Campaign14	Asset14	0
5	Campaign15	Asset15	0
5	Campaign16	Asset16	0
5	Campaign17	Asset17	0
5	Campaign18	Asset18	0
6	Campaign19	Asset19	0

[lbendlin]

PLease add the wave column to your sample data.