SAP BO to DAX

[pschnei]

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

[v-jiascu-msft · Accepted solution]

@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]

@pschnei

Hi, try this:

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