Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Dear all,
can someone help me with a measure? Please see sample data below. What I want is to return the accounts with the following criteria:
- (campaign = campaign1 & "reaction" does not contain data) & (campaign = campaign2 & "reaction" contains data) OR ((campaign = campaign1 & "reaction" does not contain data) & (campaign = campaign2 & "reaction" does not contain data))
Hope that makes sense. The result for the sample data should be Account2, Account3 and Account 5.
Thanks a lot! 🙂
Account | Campaign | Reaction |
Account1 | Campaign1 | reaction1 |
Account1 | Campaign2 | |
Account2 | Campaign1 | |
Account2 | Campaign2 | reaction1 |
Account3 | Campaign1 | |
Account3 | Campaign2 | reaction2 |
Account4 | Campaign1 | reaction1 |
Account4 | Campaign2 | reaction3 |
Account5 | Campaign1 | |
Account5 | Campaign2 |
Solved! Go to Solution.
Hi @KMZ_ESS ,
You can create a calculated column as below to get it, please find the details in the attachment.
Column =
VAR _count1 =
CALCULATE (
COUNT ( 'Table'[Account] ),
FILTER (
'Table',
'Table'[Account] = EARLIER ( 'Table'[Account] )
&& (
'Table'[Campaign] = "Campaign1"
&& 'Table'[Reaction] = BLANK ()
)
)
)
VAR _count2 =
CALCULATE (
COUNT ( 'Table'[Account] ),
FILTER (
'Table',
'Table'[Account] = EARLIER ( 'Table'[Account] )
&& ( 'Table'[Campaign] = "Campaign2" )
)
)
RETURN
IF ( _count1 > 0 && _count2 > 0, 'Table'[Account] )
Best Regards
Hi @KMZ_ESS ,
You can create a calculated column as below to get it, please find the details in the attachment.
Column =
VAR _count1 =
CALCULATE (
COUNT ( 'Table'[Account] ),
FILTER (
'Table',
'Table'[Account] = EARLIER ( 'Table'[Account] )
&& (
'Table'[Campaign] = "Campaign1"
&& 'Table'[Reaction] = BLANK ()
)
)
)
VAR _count2 =
CALCULATE (
COUNT ( 'Table'[Account] ),
FILTER (
'Table',
'Table'[Account] = EARLIER ( 'Table'[Account] )
&& ( 'Table'[Campaign] = "Campaign2" )
)
)
RETURN
IF ( _count1 > 0 && _count2 > 0, 'Table'[Account] )
Best Regards
User | Count |
---|---|
123 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
183 | |
90 | |
67 | |
62 | |
53 |