Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Filtering a Custom Column

Here's my custom column: Retained Control = VAR ThisCostCenter = 'Transactions'[COST_CENTER_ID] VAR ThisYM = VALUE('Transactions'[PROCESS_YM])  -- Convert text to number -- Find first valid PR...
  • v-sdhruv's avatar
    v-sdhruv
    1 year ago

    Hi Anonymous ,

    You can try:

    Ext. Sales PY =
    VAR MinRC = MIN(Transactions[Retained Control])
    VAR MaxRC = MAX(Transactions[Retained Control])
    VAR AllZero = MinRC = 0 && MaxRC = 0
    VAR AllOne = MinRC = 1 && MaxRC = 1

    RETURN
    SWITCH(
    TRUE(),
    AllZero, BLANK(),
    AllOne,
    CALCULATE(
    [03Total_Sales_PY],
    Transactions[Whse_Type] = "Branch",
    Transactions[Retained Control] = 0 ||
    Transactions[ACQUISITION_YR] = 0 ||
    ISBLANK(Transactions[ACQUISITION_YR])
    ),
    BLANK() 
    )

    Hope this helps!
    If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it.
    Thank You

v-sdhruv's avatar
v-sdhruv
Community Support
1 year ago

Hi Anonymous ,
Just wanted to check if you had the opportunity to review the suggestions provided?
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You