Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I am working on the following measure which however doesn't provide the expected result. The purpose of this measure is to sum column 'All base period' ignoring the clicer selection applied to column 'Segment' but adding two additional filters pertinent to columns 'Geography' and 'Cost Center'
RegionOwnedInternational = CALCULATE(SUM('AO source'[All base period]), ALL('AO source'[Segment]),Filter('AO source','AO source'[Geography]= "International" &&'AO source'[Cost Center]= "Region Owned"))
The result of this below DAX formula is 'blank'. It works correctly if I tamper with slicer interactions but eventually it's not an option because there's a couple of measures in this report which are mutually dependent so I need to have the values computed rather than steered through interactions.
The measure computes some result (not what I want though) if I delete this part:
Filter('AO source','AO source'[Geography]= "International" &&'AO source'[Cost Center]= "Region Owned"
hence I guess there must be some conflict between ALL and Filter components.
Would you have any idea what I need to change in the formula ?
Hi @Anonymous ,
I'm not aware of your dataset so I'm not certain what you want to calculate and which reason cause this issue based on your current description. Maybe modify like this?
RegionOwnedInternational =
CALCULATE (
SUM ( 'AO source'[All base period] ),
FILTER (
ALL ( 'AO source'[Segment] ),
'AO source'[Geography] = "International"
&& 'AO source'[Cost Center] = "Region Owned"
)
)
If you want to know about All() and Filter(), you can refer:
Could you please consider providing some sample data for further discussion? Sample data and expected output would help tremendously.
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
'AO source'[Cost Center] = "Region Owned"
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |