Forum Discussion

srdjanmish's avatar
srdjanmish
Helper I
6 years ago
Solved

RELATED Column with between condition

Hi Guys,   I have an issue I need to solve and it is like this:   In first table I have levels of, for example, expertise, based on point system, and it is like:   Level name Minimum Valu...
Need Help
  • az38's avatar
    az38
    6 years ago

    Hi srdjanmish 

    try a new measure

    Measure = 
calculate(
FIRSTNONBLANK('Table'[Level name];1);FILTER(ALL('Table');[YOURVALUE]>='Table'[Minimum Value] && [YOURVALUE]<='Table'[Maximum Value]
)

    do not hesitate to give a kudo to useful posts and mark solutions as solution

az38's avatar
az38
Community Champion
6 years ago

Hi srdjanmish 

try a new measure

Measure = 
calculate(
FIRSTNONBLANK('Table'[Level name];1);FILTER(ALL('Table');[YOURVALUE]>='Table'[Minimum Value] && [YOURVALUE]<='Table'[Maximum Value]
)

do not hesitate to give a kudo to useful posts and mark solutions as solution