dynamic filter? selected values?

[soogiang]

I have 3 data tables and I'd like to create a table based on the selected value (slicers/filters) 

so the output table can be changed by the selections (slicer1 and slicer 2)

slicer 1 is always from dataset A, but slicer 2 can have dataset B and C.

dataset

desired output based on the selected filter

Thank you!

[TomMartens]

Hey @soogiang ,

I have to admit that I do not fully understand your requirement, mainly I do not understand the images of the tables.

What does it mean when the desired images state "Slicer 1 - dataset B" and "Slicer 1 - dataset C"?
How it the value "Slicer 1-dataset C": 2/1/2022 = 300 computed?

Consider creating a pbix that contains sample data but still represents your data model (tables, relationships, calculated columns, and measures). Upload the pbix to onedrive, google drive, or dropbox and share the link. If you are using Excel to create the sample data share the Excel file as well.

Describe the expected output based on the sample data.

From my understanding so far you have to create a fourth table that contains the combined but unique values from the date column of the actual and budget tables. This table will populate Slicer 2. Of course, you have to create relationships between this fourth table (the one side of the relationship) and the actual and budget table (both tables will be on the many side of the relationship).

Create two measures on that calculates the difference between Plan and Actual and one that calculates the difference between Plan and Budget.

Hopefully, this provides an idea of how to tackle your challenge.

Regards,

Tom

[soogiang]

Thanks Tom,

I updated the sample image.. so slicer 1 needs to reflect dataset A, slicer 2 needs to reflect dataset B and C.

so trying to compare dataset A to dataset B or dataset C.

I will try your suggestion.

Thanks