Count Blank Values with Others in Measure

[sleekpeek]

I have the query below. For segment, I need to count 2 values (value 1 and value 2) plus any blank values into the query.   Can I do this?

[i've amended the table and field values below to generic ones]

CALCULATE(SUM(Opp[ARR]), FILTER(Opp, Opp[StageName] IN { "3", "4}), FILTER(Account, Account[Segment] IN { "value1", "value2"}),USERELATIONSHIP(date[Date])) etc

Thanks

[smpa01]

@sleekpeek  Can you try the following

CALCULATE(SUM(Opp[ARR]), FILTER(Opp, Opp[StageName] IN { "3", "4}), FILTER(Account, Account[Segment] IN { "value1", "value2", BLANK()}),USERELATIONSHIP(date[Date]))

[amitchandak]

@sleekpeek , try like

CALCULATE(SUM(Opp[ARR]), FILTER(Opp, Opp[StageName] IN { "3", "4}), FILTER(Account, ( Account[Segment] IN { "value1", "value2"}  || isblank(Account[Segment])   ) ),USERELATIONSHIP(date[Date]))

[sleekpeek]

I tried, and get this error

[sleekpeek]

when I add in BLANK() the query accepts it, however the values do not change and i'm missing a considerable amount 🙂 I've checked my visual, page and all pages filters and i'm not filtering anywhere to exclude these blanks.

when exporting, it looks like this:

The segment field references the field to the left ... should I add something to the segment field instead?

any other suggestions guys .. thanks so far

[smpa01]

@sleekpeek  is there any way you can provide a minimum reproducible example of your issue?

[sleekpeek]

thanks for the suggestion, I don't think I can.  My issue stems from the owner_segment field not (a) having the values we need for a high level segment and (b) not being mandatory hence the blank fields.  The regional segment is a data group field bucketing lots of values from the owner_segment field into 3 values only, however you cannot bucket "blank" I believe.  I think my solution is to ensure that sales ops complete that field on all sales user profiles in the data source.