DAX concepts / Filter behaviour

Question

I am having question which i didn't think before,but i am not sure the way i think is correct.Scenario 01I am having three tables(company,customer and fact table called tnx) ,total Ar amount is just sum of tnx.I have a relationship to company to fact and customer to fact as star schema.When i select company code from company table as slicer,&nbsp; total is changing .that is obvious,but how customer figures are changing cos there is no direct relationship with company and customer and direction is also uni directional .Is that company filter fact table and then as reverse filter, fact table filter out customer. Ijust want to know the way i think is correct.Customer is indirectly filter by company via fact as i understood.&nbsp;Scenario 02This uses also same three tables ,customer company and fact .Here i rank amount based on customer parent id (1 st column)The DAX i used =var&nbsp;_step1&nbsp;=IF&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;ISINSCOPE&nbsp;(&nbsp;CUSTOMERS[CUSTOMER_PARENT_ID_REPORTING]&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;IF&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;HASONEVALUE&nbsp;(&nbsp;CUSTOMERS[CUSTOMER_PARENT_ID_REPORTING]&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;RANKX&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ALLSELECTED&nbsp;(&nbsp;CUSTOMERS[CUSTOMER_PARENT_ID_REPORTING]&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CALCULATE&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[Total&nbsp;AR&nbsp;Amount],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ALLEXCEPT&nbsp;(&nbsp;CUSTOMERS,&nbsp;CUSTOMERS[CUSTOMER_PARENT_ID_REPORTING]&nbsp;)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;DESC,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;DENSE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;)&nbsp;&nbsp;&nbsp;&nbsp;))&nbsp;So I get the values as in 6 th column and 7 th column is just sum(amount) as 1st scenario. What i am going to achieve is customer parent level ranking based on amount.But what happen if i slice by company code.Company code column is not on visualBut when i click company code slicer for a particular company code i can see value changes also parent id changes.But the DAX, i wrote to calculate [Total AR Amount] i wrote with ALLEXCEPT,so it remove all filters except Customer parent id.But since i have used allselected for customer_parent _id reporting now how this flows goes on.This is difficult to understand how this is behaving now with rank.I am not sure the final answer i am getting is right.what i finally want is dynamcially rank based on external slicers and show the total based on customer parentCan you all help me with this.&nbsp;

lbendlin · Answer

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.

If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Forum Discussion

DAX concepts / Filter behaviour

1 Reply

Related content

partitioning concept

Same Filters - Different Behaviour

Strange CLOSINGBALANCE behaviour

Matrix behaviour multiple parameters

REMOVEFILTERS() Unexpected behaviour