How to use measure expression as a dimension or in a filter

[mahnoor1279]

Hello everyone ,

IF(SUM({<[TRANSACTION_TYPE] = {'SALE'}, [NET_AMOUNT] = {">=5000000"}>} [NET_AMOUNT]),'GREATER','LESS')

i've this  expression and i want to use this as a dimension or as a filter in dashboard ,

[sidhiq91]

@mahnoor1279  May be you can try to create a flag using the same expression in your load script something like below:

Load *,

if(([TRANSACTION_TYPE] ='SALE' and sum([NET_AMOUNT])>=5000000),'GREATER','LESS) as Flag

From Table_Name

Group by Fields;

In the front end you can use the Flag as a filter or Dimension.

If this resolves your issue please like and accept it as a solution.