In the table below I want to show the opposite result without using additional slicers.
That means, if I choose Company = 160 and IC PartnerCompany = 180, all results for this selection should show up in the above table. → Done
In the table below, the cloumn company should be filtered by 180, and the IC PartnerCompany by 160.
Unfortunately, all my attempts so far come up empty and give errors or don’t work properly : vice versa = FILTER(VALUES(FactTable[Company]), SELECTEDVALUE(dim_ICPartnerCompany[IC Partner Company]))
Hi @d.mesch, due to inactivity, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box.
sorry for the late answer, but i was in between in another urgent project.
sorry also for the incorrect solution message, the system has assigned it due to my absence.
I tried your solution, but somehow I don’t get it to work.
I build up the tables, I build up the measures. But how I need to set the filters correctly to get it work? Can you still describe/show me this way.
@Rajesh
hmmm… it seems that i was too early. The slicer for the IC Partner Company does not filter the IC Partners for me. It does nothing at all. If I have several IC partners for one company, they are all displayed, no matter what I set.
Could you kindly tell me again how to set the filters so that they work?
In all tables only the company and IC partner should be displayed, which is set in the slicer.
Somehow I did not manage to set the slicer the right way.
As usual, I would expect that only the values that are set via the slicers are displayed in the two right tables.
Do you want to select multiple values in slicers or only one value ?
If you select 160 from Company and 100 from IC Partner , third table we’ve to show 100 company and 160 ICP Partner right ? but we don’t have company 100, in this case how you want to show third table ?
yeah you’re right. My mistake. I wanted to be quick and did not build the data quite correctly. The dim_Company corresponds 100% to the dim_ICPartner Company.
I have added the data and reattached.
For your 1. question - In everyday work, a single selection will suffice.
Where would be the difference to a multiple selection in the structure of the formulas?
While our users and experts do as much as reasonable to help you with your inquiries, not all concerns can be attended to especially if there are some learnings to be done. Thank you!
