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]) Where (Not (IsNull([Registration status])))

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

     

     

     

2 Replies

  • 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))

  • 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