Calculate less than selectedvalue (CALCULATE(['Actual],'G/L Account'[A.No]<SELECTEDVALUE()

[Rygaard]

The problem:

CM1=CALCULATE(['Actual],'G/L Account'[A.No]<SELECTEDVALUE(Ark1[konto]))   - NOT workding

CM1=CALCULATE(['Actual],'G/L Account'[A.No]<21000) - Working

I have a messure that works just fine:

CM1=CALCULATE(['Actual],'G/L Account'[A.No]<21000)

and another

CM2=CALCULATE(['Actual],'G/L Account'[A.No]<27000)

instead of making cm1, cm2, Ebit, Ebitda, and and so on i wanted it dynamic so i made  a table

NAME KONTO

Cm1  21000

cm2   27000

Ebit   50000

EBITDA  45000

......

if i make a slicer and select CM1   and write a measure like

Selected Account= SELECTEDVALUE(Ark1[konto])    and stick that on  a Card i get 21.000  - Perfect

But if i try to use that as a filter it wont work

CM1=CALCULATE(['Actual],'G/L Account'[A.No]<SELECTEDVALUE(Ark1[konto]))   - NOT workding

CM1=CALCULATE(['Actual],'G/L Account'[A.No]<21000) - Working

i get the error :" A functil ' SELECTEDVALUE' has been used in a True/false expression, that is used as a table filter expression, this is not allowed."

Any sugestions on how to make this work ?

[amitchandak · Accepted solution]

@Rygaard , Try like

CM1=CALCULATE([Actual],filter('G/L Account','G/L Account'[A.No]<SELECTEDVALUE(Ark1[konto])))

or

CM1=
var _1 = SELECTEDVALUE(Ark1[konto])
return
CALCULATE([Actual],filter('G/L Account','G/L Account'[A.No]<_1))

[Rygaard]

#imstupid  the main reason it did not work was ofc. that i made a connection between my selection table and the Acount table -  witch ofc applyed the selection across all calculations.. after i removed that it worked as it should... 

@amitchandak