Forum Discussion

_chris_'s avatar
_chris_
Helper III
3 years ago
Solved

Simple DAX issue

Hi,   I have 2 tables:   1. DIM table: CostCenters   -Id   2. FACT Table: Revenue   -OriginalId   -NewId   -Amount   There is a relation between CostCenters.Id and Revenue.NewId and I can...
  • Samarth_18's avatar
    Samarth_18
    3 years ago

    Hi _chris_ ,

     

    If I understand your question correctly then you need follow below steps:-

    1. Create a inactive relationship between CostCenters.Id and Revenue.OriginalId

    2. Create a measur as below:-

     

    measure_ =
CALCULATE (
    SUM ( Revenue[Amount] ),
    USERELATIONSHIP ( CostCenters[Id], Revenue[OriginalId] )
)

     

     

Samarth_18's avatar
Samarth_18
Community Champion
3 years ago

Hi _chris_ ,

 

If I understand your question correctly then you need follow below steps:-

1. Create a inactive relationship between CostCenters.Id and Revenue.OriginalId

2. Create a measur as below:-

 

measure_ =
CALCULATE (
    SUM ( Revenue[Amount] ),
    USERELATIONSHIP ( CostCenters[Id], Revenue[OriginalId] )
)