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

v-juanli-msft's avatar
v-juanli-msft
Community Support
6 years ago

Hi srdjanmish 

srdjanmish's suggestion should be helpful.

 
If it is sloved, could you kindly accept it as a solution to close this case?
If not, please feel free to let me know.
 
Best Regards
Maggie
  • srdjanmish's avatar
    srdjanmish
    Helper I
    6 years ago

    Hi,

     

    I am in middle of transfering and modeling data for this example, and, as soon as I get to test it, I vil give feedback. I think this is OK, and it will work..