Forum Discussion

LeoST's avatar
LeoST
Frequent Visitor
5 years ago
Solved

Switching between two relationships between two tables

Hello,   I've two tables that are conneted by two relations. One table is costs and the other is Projects. They have an active relation based on there ID columns and an inactive relation between C...
  • amitchandak's avatar
    amitchandak
    5 years ago

    LeoST , Try like

    Measure =
    CALCULATE(
    FIRSTNONBLANK(Projects[Name],TRUE()),
    USERELATIONSHIP(Costs[Source ID], Projects[ID]))

     

    Not need crossfilter

    refeR: https://youtu.be/e6Y-l_JtCq4

amitchandak's avatar
amitchandak
Super User
5 years ago

LeoST , Try like

Measure =
CALCULATE(
FIRSTNONBLANK(Projects[Name],TRUE()),
USERELATIONSHIP(Costs[Source ID], Projects[ID]))

 

Not need crossfilter

refeR: https://youtu.be/e6Y-l_JtCq4