Forum Discussion

markjankowski's avatar
markjankowski
Frequent Visitor
3 years ago

Dax & allselected

I have the following statement but syntax states incorrect?

 

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

5 Replies

  • markjankowski's avatar
    markjankowski
    Frequent Visitor
    3 years ago

    i think this will work...

     

     

    M2A = if(isblank(SELECTEDVALUE(W2E_Master[Value])),0,[Measure])
    • markjankowski's avatar
      markjankowski
      Frequent Visitor
      3 years ago

      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]))
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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