Forum Discussion

rishari's avatar
rishari
Frequent Visitor
3 years ago
Solved

SAP BO to DAX

Hello there, can someone help me to translate this SAP BOBJ query to DAX.

Variable A = Sum(Round(Count ([S_ID] ) Where ([ID]<>"X" And ([Var o]-[Var i])>0);0) ForEach([S_UID4];[S_ID]))

Please provide me an optimized DAX measure. I'm new to DAX, Kindly help me.

 

Appreciate your effort and time to help me.

 

Thanks in advance.

Vvelarde olgad v-jiascu-msft 
 

Need Help
  • Kishore_KVN's avatar
    Kishore_KVN
    3 years ago
    A = Calculate(Sum(Round(Count([S_ID]))),Filter(Table, [ID]<> "X" && ([Var o]-[Var i])>0),
ALLEXCEPT([S_UID4]))

     

    As per my understanding of the columns I have written this. You may need to modify as per your table and column names. 

     

    If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!

1 Reply

  • Kishore_KVN's avatar
    Kishore_KVN
    Icon for Solution Sage rankSolution Sage
    3 years ago
    A = Calculate(Sum(Round(Count([S_ID]))),Filter(Table, [ID]<> "X" && ([Var o]-[Var i])>0),
ALLEXCEPT([S_UID4]))

     

    As per my understanding of the columns I have written this. You may need to modify as per your table and column names. 

     

    If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!