logic

[smilingjohn]

In the dimension i have to consider a Filed called IDNumber...

Iam writing the below expression

If(Status'Active'IDNumber)

Where ever the status is Active i want to display only those IDNUmber's

Is the above expression in the Dimension is correct

[Anil_Babu_Samineni]

May be these?

If(Match(Status,'Active'),IDNumber)

OR

If(Status Like 'Active', IDNumber)

[sunny_talwar · Accepted solution]

You can also do this

If(Status = 'Active', IDNumber)

and then make sure to check 'Suppress When Value Is Null' on the dimension tab of the chart properties

[sudeepkm]

I think you may also try using the condition in your expression instead of Dimension as another approach.

=sum({< Status={'Active'}   >}OrderID)