cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Tables relatationship not working as expected.

I have five tables and they are related to each other like this:

relationship.png

 

 

 

The table Vendas contains informations about sales, MetaComissaoCor is about goals. The table Vendedor contains informations about sellers, the table Cor has sales category and the table VendedorECor contains information about a seller and the categories he works.

I have to create two visuals. the first one is a matrix with categories by name, its goal and its accomplished. And the other one is a slicer that filter the matrix by a seller.

The problem is that the slicer does not work, it only shows the grand total value and filter the seller's categories.

 

These are my visulas without any values selected in the slicer, you can notice that META_VALOR (MetaComissaoCor) and VRTOTITEMLIQ (Vendas)  have the same values for all NOMES2 (VendedorECor). But it is not true, the goals and accomplished are different in each category.notfiltred.png

And if I apply any filter on my slicer the matrix only shows, as expected, the selected seller's categories (NOMES2) . But the values continue unchanged, like this:filtred.png

 

 

 

 

What do I have to change on my tables relationship to fix this problem?

 

 

3 REPLIES 3
Anonymous
Not applicable

I was able to simplify my problem to this: 

simple.png

 

 

So now I'm able to filter META_VALOR (MetaComissaoCor) on my matrix, but the VRTOTITEMLIQ (Vendas) column is not being filtered. 

simplematrix.png

 

 

What can I do to fix my new problem?

Super User I
Super User I

@Anonymous you need to understand the direction the arrows are going in.  probably best to change some of your relationship  type to bi  (both) directional and not single direction so that you can filter correctly





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Anonymous
Not applicable

@vanessafvg, thank you for helping me. I did not known abou the arrows directions. Now I known why it is not working. But, I don't known how can I fix it. Can you help me?

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors