Filter measure with seperate table

[jackiekim]

Hi, I am new to PowerBI,

I have a measure looks like : %Year = DIVIDE(SUM(Shipment[Profit]),SUM(Shipment[Revenue]))

 And I have Score Table which is separated

ScoreID	%From	%To	Score
1	0	5	1
2	5	15	2
3	15	25	3
4	25	45	4
5	45	60	5
6	60	100	6

I would like to make a measure called Score and show Score[Score] filtered by %From <= %Year < %To 

ex) Score = Calculate(Score[Score], Filter(Score[%From] <= Shipment[%Year] < Score[%To] 

Thank you

[Vvelarde]

@jackiekim

Hi, please try:

ScoreM = Calculate(Values(Score[Score]), Filter(Score, Score[%From] >= [%Year]  && Score[%To] < [%Year])) 

[jackiekim]

Hi, Thanks for the reply,

I tried with your suggestion, 

I got error 

Couldn't load the data for this visual

MdxScript(Model) (14,42) Calculation error in measure 'Shipments'[ScoreM]: A table of multiple values was supplied where a single value was expected.

Could you help me more?

[jackiekim]

If I hard code the value [%Year], it's working 

ex) ScoreM = CALCULATE(VALUES(Score[Score]),FILTER(Score,Score[%From]<=4.5 && Score[%To]>=4.5))

[Vvelarde · Accepted solution]

@jackiekim

just add some code in the measure:

ScoreM = IFHASONEVALUE(TABLE[YOURCOLUMN]),Calculate(Values(Score[Score]), Filter(Score, Score[%From] >= [%Year]  && Score[%To] < [%Year])) )