Forum Discussion

devenk2's avatar
devenk2
Frequent Visitor
3 years ago
Solved

Fixing (Blank) when Filtering Columns in Many to One Relationship

Hello,   I am making a scorecard for some metrics, which requires me to calculate grades for certain applications based on the severities of a number of security incidents. I have two tables, one w...
Need Help
  • devenk2's avatar
    devenk2
    3 years ago

    I was able to resolve this by building the following measure which references the grade column.

     

    TM Grade Not blank = IF(ISBLANK(FIRSTNONBLANK(TMScoreTable[Grade], TMScoreTable[Grade])), "-", FIRSTNONBLANK(TMScoreTable[Grade], TMScoreTable[Grade]))
devenk2's avatar
devenk2
Frequent Visitor
3 years ago

I was able to resolve this by building the following measure which references the grade column.

 

TM Grade Not blank = IF(ISBLANK(FIRSTNONBLANK(TMScoreTable[Grade], TMScoreTable[Grade])), "-", FIRSTNONBLANK(TMScoreTable[Grade], TMScoreTable[Grade]))