Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Unrelated Tables. Sync Dimension/Slicer

Hi,

 

i am facing the following situation.

In a Model I have a Fact Table that is duplicated. This is because I want to filter the Fact_Copy to see the Number of Contracts that have a starting status and see how the status changed over Time. But i have another Dimension called "Type". I want to filter on the type too, but in both fact tables.MOdelMOdel

This is the Example. On left side we see the fact tables content. On the right how i want to use the Model.

As IsAs Is

What I want to have is, that type is filtered as in Type_Copy. At the moment the End User has to set both filtersSyncSyncIs there any chance to get this working. I actually need a Solution in SSAS Tabular. So this should work in PowerBI and Excel connected to the Tabular Model.

Or am I totally on the wrong path?

 

Best Regards

3 REPLIES 3
V-lianl-msft
Community Support
Community Support

Try to create measure like below and apply the measure to visual level filter:

Measure = IF(MAX('Table'[Status]) in VALUES('Table 2'[Status_copy]) && MAX('Table'[Type]) in VALUES('Table 2'[Type_copy]) ,1,0)

Vlianlmsft_0-1637827109393.png

 

Stachu
Community Champion
Community Champion

I do not understand why you need a copy of the fact table to look at the status over time, why not just use the original table? From what I see you may need duplicate Type/Status tables to have separate slicers and a custom measure to ignore one or the other



Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

Anonymous
Not applicable

Hi @Stachu ,

 

thanks for your feedback.

can you give an example of such a Measure or any hint to one?

 

Best Regards

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.