Filters with no repurcussions on the entire data model

[Sibrulotte]

Hi, 

I'm an experienced Qlikview developper, and I'm trying to figure out some things about Power Bi that I probably don't get yet.

I have a data model:

Transactions:

Account_ID, Date, Sequence_no

Accounts:

Account_ID, Category_ID, User_ID

Users:

User_ID, User_code

Categories:

Category_ID, Category_Name

If I have a matrix with Categories.Category_Name as row, and count(Transactions.Account_ID) filtered by Transactions.Sequence_No = 1.

I have satisfying results. 

But the same matrix with Accounts.Account_ID, the sequence_No just says goodbye, don't care, you're on your own... And I get the full list of possible Accounts that exist for the Categories.

I've tested my relationships and they are all on the same field formats, regular table gives me proper values all well aligned, so I know it's not my keys...

What do I not understand about Power Bi? 

[HarishKM]

@Sibrulotte Hey Mate ,
for the 1st statements :  Categories.Category_Name as row, and count(Transactions.Account_ID) filtered by Transactions.Sequence_No = 1 but for the 2nd statement  Accounts.Account_ID, the sequence_No .  You are not passing any filter or slicer if you want to slicer and dice the data then kindly hard code it using different filter available in power bi or use slicer to slicer and dice the data .For a taste you can use Transactions.Sequence_No = 1 . It will slice and dice where Transactions.Sequence_No = 1 .


If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.

[pranit828]

Hi @Sibrulotte 

Can you please provide more info with screenshots, input and required output in table format for the community so that you ask can be better understood and resolved quickly.

[Sibrulotte]

You aske for a print screen, but my actual data model is a bit more complexe. Anyways, the principle is the same. 

I have a slicer with Dates in the calender above (not shown), that is join by the DateReport_date. 

I have a matrix with a Filter on Sequence number that gives this result:

So the first colomn is a count from Tansactions table, which is perfect, it slices with the proper Sequence, but the second is from the account table and it is just a listing of all the accounts that had transactions during those dates, but disregards the SequenceNo filter, and the third is the user id (a user can have multiple accounts) and is maybe a key issue, but I double checked it, don't get that one. 

[v-kkf-msft · Accepted solution]

Hi @Sibrulotte ,

Try to change the direction of cross filtering between the Transactions table and the Accounts table to Both.

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.