How can I use user selection in order to filter a table? (Dim table is not connected to the Fact)

[Gefen_Co]

Hi All 😊

I have a Dim table that is not connected to the Fact table, as there is no connection that can be established.

In the Dim I have 2 columns => Date + Value.

The user is choosing the Date from a slicer (from the Dim table). 

I want that the Fact table will be updated as follows:

If the date in the Fact column is bigger than the user-selected Date,

a specific column in the fact table will be multiplied by the Dim Value.

How can i do this?

appreciate any help.

Gefen

[Anonymous · Accepted solution]

Hi @Gefen_Co ,

According to your description, here are my steps you can follow as a solution.

(1) This is my test data. 

DimFact

(2) We can create a measure. 

updated column = IF(MAX('fact'[date])>SELECTEDVALUE('Dim'[date]),MAX('fact'[specific column])*SELECTEDVALUE('Dim'[value]),MAX('fact'[specific column]))

(3) Then the result is as follows.

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

Best Regards,

Neeko Tang

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