Forum Discussion

SC_Developer's avatar
SC_Developer
Frequent Visitor
3 years ago

Tooltip Table that needs to activate Relationships

Hi guys!

 

I would need your help once more for a Power BI Desktop solution.

 

Context

I am using a Maxtrix-visual, where both dimensions (year and category) are linked to the fact table by the use of USERELATIONSHIP in the measure.

 

 

 

 

 

 

 

 

 

Challenge

I want to add a Table-visual with a single column listing the corresponding project names as a tooltip. How can I active the relationships in that table? My idea to use CALCULATETABLE with the identical USERELATIONSHIP-formulas as in the measure failed. It created another table that isn't related to the dimensional tables and would therefore provide the same list of projects for every cell.

 

Thanks for your help.

 

Cheers, Martin

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi SC_Developer,

    I'd like to suggest you directly extract the current category fields values and use them as condition to lookup fact table records:

    formula =
VAR currCate =
    SELECTEDVALUE ( Table[Category] )
VAR currYear =
    MAX ( Date[Year] )
RETURN
    LOOKUPVALUE (
        'Fact'[ProjectName],
        'Fact'[Category], currCate,
        'Fact'[Year], currYear
    )

    Regards,

    Xiaoxin Sheng

    • SC_Developer's avatar
      SC_Developer
      Frequent Visitor
      3 years ago

      Thanks for your suggestion. I am not sure if LOOKUPVALUE works if there are several results (from several rows) that match the criteria.