Forum Discussion
Building Relationships on multiple tables with no unique values
Hi Anonymous ,
You mean to take the Segment field of the Forecast table as a slicer, filter the fact table, right? You can create a measure and then place [Measure=1] on the filtering of the visual.
Measure = IF(MAX('Fact sales'[Segment]) in VALUES('Forecast'[segment]),1,0)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.
Hi Anonymous ,
You can consider creating a separate subdivision table as one end table and other tables to create model relationships, or if you have multiple relationships, you can use the USERELATIONSHIP() function to activate inactive model relationships.
For more details, please refer: Financial Statement Analysis with Power BI - Microsoft Fabric Community
Financial Modeling in Power BI: Templates & Insights | Inforiver
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.
The things is though, I don't have multiple relationships within my model. Each of my tables have one relationship with another. But I'm struggling to form any kind of relationship between my budget tables and my product dimension because there are no unique values. My slicers aren't effective due to no relationship being formed. Is there a DAX measure I can implement to help?
Hi Anonymous ,
You mean to take the Segment field of the Forecast table as a slicer, filter the fact table, right? You can create a measure and then place [Measure=1] on the filtering of the visual.
Measure = IF(MAX('Fact sales'[Segment]) in VALUES('Forecast'[segment]),1,0)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.