Dax & allselected

[markjankowski]

I have the following statement but syntax states incorrect?

M2A = if(isblank(ALLSELECTED(W2E_Master[Value],0,W2E_Master[Value]))))

[v-shex-msft]

HI @markjankowski,

I'm glad to hear you found and share the solution formulas here, I think they will help other who has the same requirements.
Regards,

Xiaoxin Sheng

[markjankowski]

i think this will work...

M2A = if(isblank(SELECTEDVALUE(W2E_Master[Value])),0,[Measure])

[markjankowski]

[markjankowski]

ok, i tried a few variations and tested with this one against the database it it works in every case on the screen...

M2A = IF(SELECTEDVALUE(W2E_Master[Value])=BLANK(),0,MAX(W2E_Master[Value]))

[markjankowski]