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.
@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]))
@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]))
I tried, and get this error
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
@sleekpeek is there any way you can provide a minimum reproducible example of your issue?
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.
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 |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |