cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
wilson_smyth
Helper V
Helper V

displaying values in table, filtered on another visualization, but with no measure

I have a model with two fact tables & multiple shared dimensions.

Note, this is a contrived example with junk data purely to illustrate a problem im trying to solve.

 

img3.JPG

 

Im doing a fairly basic report to show mappings between objects in a matrix, and two seperate tables to give details of each of the objects.

img 1.JPG

 

This is easily accomplished for one chart on this fact table.
Obj 2 is filtered because the measure in the matrix is providing the filter.

Obj 1 is filtered as i have enabled cross filtering on the obj1 < fact 1 relationship.

 

The difficult comes when trying to do something similar for fact 2. Im not using a measure, just a table containing Obj4 values that should filter obj 2 values in a seperate table.
Im not using a measure so filter contex cant come from there & i have nowhere to add a crossfilter dax function.
I cant enable cross filtering as i get an ambigous model.


Is there a way to get report 2 working, so that table 1 filters table2 without using a measure?

Img 2.JPG

 

 

The following link is to the pbix file contiaining this example. Appreciate any advise on if what i want to do is possible.

Link
Thanks!

 

2 REPLIES 2
rajulshah
Solution Sage
Solution Sage

Hello @wilson_smyth,

 

Please change the relationship between Obj2 and Fact1 as bi-directional relationship as follows;rel.JPG

 

Hope this works as your expectation! 

 

 

CheenuSing
Community Champion
Community Champion

Hi @wilson_smyth

 

 

Based on my test result it works. 

 

May be try creating the Report2 again by deleting all the objects.

 

 

Cheers

 

CheenuSing

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors
Top Kudoed Authors