Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
the measure below isn't behaving as expected. The agreement table connects to the snapshot with filters in both directions and then the onBook table connects to the snapshot with single direction filters.
If I set the filter direction on the agreement-snapshot link to single the measure behaves as expected but a lot of other things break. I don't understand why the ALL(OnBook) is letting the measure return different values based on fields in the OnBook table.
# Agreements = DISTINCTCOUNT(Agreement[PKAgreement])
# Agreements All MoBs =
CALCULATE(
[# Agreements]
,ALL(OnBook)
)
Hi @alec20191104 ,
Based on your description, the two measures are based on different tables. However, the actual situation is based on the Agreement table, and the all function does not take effect.
If the problem persists,could you share the sample pbix via cloud service like onedrive for business?
Please remove any sensitive data before uploading.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
There is probably a logical explanation for the behaviour you are seeing, but without being able to see an example dataset that shows the issue you are seeing it's pretty hard to say what this might be.
However since you've identified that changing the relationship to a single direction fixes this particular measure there may be a solution to your issue. And that is to use the CROSSFILTER function to change the behaviour of the relationship for this one measure only.
eg.
# Agreements All MoBs =
CALCULATE(
[# Agreements]
,ALL(OnBook)
, CROSSFILTER( <many-side-column>, <one-side-column> , one)
)
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.