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

     

     

     

Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
9 years ago

pschnei

 

Hi, try this:

 

Measure=Calculate(Count(Table[GroupID]),Filter(Table, Table[RegistrationStatus]<>Blank))