I don't understand filter propagation.

[notofrugo90]

Please disregard what I want to achieve here. My question is purely about technial part of DAX and relationships in Power BI.

My question is about this strange behavior of DAX which I don't understand. My measure should simply count rows in DIM_VENDING_MACHINE and somehow values returned by this measure are affected by DIM_CUSTOMER. Why? I should get exactly the same number in each row of that table since filter cannot be propagated from DIM_CUSTOMER to DIM_VENDING_MACHINE because of the filter direction between DIM_VENDING_MACHINE and FAC_SALES_VENDING.

I have already achieved what I wanted. I just don't understand this behavior I noticed. And I like to understand how things work.

[lbendlin]

"Follow the arrows."  Can you get there from here?  In your case you cannot get from the Customer dimension to the Vending Machine dimension, as the arrows don't cooperate.  So Power BI is giving you a fake result.  

In your case you would need to use the Fact table and Filter transfer (via TREATAS for example) to calculate how many vending machines each customer has used in their purchases.

[KarinSzilagyi]

Hi @notofrugo90, is the "Customer Number" you're using in the table from your Dim_Customer or your "Fact_Sales_Vending"? If it's from your Dim_Customer the other dimension should not impact the count in any way. If the column is from your fact table it makes sense though, since your fact table is filtered by Dim_Vending_Machine, so the countrows gets evaluated on each row that can be found in the current filter context in your fact table.