Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
why interaction work only in one direction? Same code in other pbix file work like expected, but here not work, why?
https://filebin.net/97ae1ztowkykeyje
Hi @Analitika ,
_Stock =
IF (
ISFILTERED ( 'Category'[short] ),
CALCULATE (
[_EUR, end],
FILTER (
VALUES ( 'pre_kod BRIDGE'[PRE_KOD] ),
COUNTROWS (
FILTER (
'Category',
[_categories]='Category'[short]
)
) > 0
)
)
)
The context of this measure contains pre_kod BRIDGE'[PRE_KOD] columns, and there is no relationship between the pre_kod BRIDGE table and Category table. The context environment will affect measure, while the actual column will not be affected by selecting measure.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.