Forum Discussion

ercwebdev's avatar
ercwebdev
Frequent Visitor
5 years ago
Solved

How to display info from another table?

Hi all, I'm really not sure what structure of DAX to use for this problem. I have 2 tables, one with the Projects and another table with all of the risks for the projects, so it is a one to many rel...
DAX
  • wdx223_Daniel's avatar
    wdx223_Daniel
    5 years ago

    ercwebdev if you are creating a calculated column, try this code

    =COUNTROWS(FILTER(RELATEDTABLE(Risks),Risks[RiskColour]="Red"))

    if you are creating a measure, think the code of CNENFRNL might work well.

ercwebdev's avatar
ercwebdev
Frequent Visitor
5 years ago

Hi Daniel,

Thanks  - that works! Much appreciated. I knew there must be a way of doing this, but it's alwasy easy if you know how. Many thanks to both for your help. 

Cheers

Alan 

ercwebdev's avatar
ercwebdev
Frequent Visitor
5 years ago

Just a quick footnote on this - the 'accepted solution' filters the records based on IDs, i.e .it will only return records that have red risks, so it removes all other records instead of including them but giving them a value of zero.