Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Date table and multiple columns/tables

Hi all,  Hi all,    I have a data table as part of my report - however, I have 3 separate dates that I need it to associate with across two tables. For example: Contact table - Latest review C...
Need Help
  • johnt75's avatar
    johnt75
    3 years ago

    You can activate the relationships inside measures, e.g. 

    Num reviews =
CALCULATE (
    COUNTROWS ( Contact ),
    USERELATIONSHIP ( 'Date'[Date], Contact[Last review date] )
)

Num contacts =
CALCULATE (
    COUNTROWS ( Contact ),
    USERELATIONSHIP ( 'Date'[Date], Contact[Last contact date] )
)
johnt75's avatar
johnt75
Icon for Super User rankSuper User
3 years ago

You can activate the relationships inside measures, e.g. 

Num reviews =
CALCULATE (
    COUNTROWS ( Contact ),
    USERELATIONSHIP ( 'Date'[Date], Contact[Last review date] )
)

Num contacts =
CALCULATE (
    COUNTROWS ( Contact ),
    USERELATIONSHIP ( 'Date'[Date], Contact[Last contact date] )
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Ah - perfect! Thank you so much