Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Building Relationships on multiple tables with no unique values

I have a report with a FactSales table and 2 dimensional tables (customer and product).  My question pertains to my product dimesional table, which has columns such as the product number, product li...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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. 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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?

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.