How to get a list from other table

DAX DAX Calculations
1

Hi guys,

I have a list in my visual that already filtered by other table, so the filtered is this one →
image

But when I test the result by creating a table with DAX :

test = ALLSELECTED(Profile[Type])

Then when I show another visual just to show the table test, it is listed me the whole rows of origin table (table Profile). This is also happened if I’m using VALUES(Profile[Type])

Something like this on my page now :

image
image691×467 60.5 KB

How to get the same list ?

Thnks,

2

Hi ,

The profile has active filter as you mention in your description but when you create the above test table where are you viewing it?

I am assuming you are viewing it on table view so in their is no active filter you have to mimic filter by yourself and you will same result.

Let me know if this solve your issue if not then can you be more descriptive about your query and if able to provide a pbix that it will be grt also.

Thanks

3

Hi Anurag,

The table test is created with that DAX command → ALLSELECTED, so I’m quite confuse how to answer where I’m viewing in that picture. If it is in table view, yes, it is showing all rows as well, and I though the same as you’re mentioned whereby there is no filter in table view. But in that picture is displayed in report view.

When I double check again, in report view, there is no filter on both. The two table visual are with the same filter like this :
image

But as mentioned, the 1st one, is filtered by its relationship to other table. And the test table is for me to check only → test = ALLSELECTED(‘Business Profiles’[Business Type]), from what I think is I would have the same list.

Sorry, I am quite new to this DAX language.

Btw, this testing is actually still related to my other thread question → How to filter table in visual based on other unrelated table
which I’m still struggling to fix that :sweat_smile:

So this test table is only for testing for the original purpose on the other thread.

Thanks

4

Hi @Toni, did the response above help in solving your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query. Thanks!

5

Hi @Toni, it’s been a while since we got a response from you. In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.

6

Hi @Toni, 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.