Forum Discussion

pschnei's avatar
pschnei
Regular Visitor
9 years ago
Solved

SAP BO to DAX

Hi there, Can someone help me to translate this simple query in DAX language? I don't understand how to transform the WHERE clause. Thank you for your help Paola   =Count([Groupment Id]) Wher...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    9 years ago

    pschnei

     

    Hi,

     

    Vvelarde is almost there. I am going to make a little change. (Just the parenthesis in blue).

    Measure =
CALCULATE (
    COUNT ( Table[GroupID] ),
    FILTER ( Table, Table[RegistrationStatus] <> Blank ())
)

    Best Regards!

    Dale

     

     

     

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

pschnei

 

Hi,

 

Vvelarde is almost there. I am going to make a little change. (Just the parenthesis in blue).

Measure =
CALCULATE (
    COUNT ( Table[GroupID] ),
    FILTER ( Table, Table[RegistrationStatus] <> Blank ())
)

Best Regards!

Dale