IF Statement - Custom Column + Measure

[Anonymous]

Hi all,

I have a table where the second last column (Total number of products launched) is a custom column, and the last column (number of products launched for the selected years) is a calculated measure using DAX language and it is the one that can adapt to the selected years filter. 

My goal is to add add a flag as a column/ calculated DAX measure with a condition, if the last 2 columns in the table are the same - the returning value is True otherwise, False. However, using a true or false column is displaying the same information: True. 

Please help! Thank you. 

[v-yangliu-msft · Accepted solution]

Hi  @Anonymous ,

I created some data:

Here are the steps you can follow：

1. Create calculated column.

Total number of products launched_Column =
SUMX(FILTER(ALL('Table'),'Table'[Group]="launched"),[product number])

2. Create measure.

number of products launched for the selected years =
var _select=SELECTEDVALUE('Table'[Year])
return
SUMX(FILTER(ALL('Table'),'Table'[Group]="launched"&&'Table'[Year]<=_select),[product number])

Flag =
IF(
    MAX('Table'[Total number of products launched_Column])=[number of products launched for the selected years],"True","False")

Flag1 =
IF(
ISERROR(
        SEARCH("True",[Flag]))
    ,
    "true",
    [Flag]
)

3. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[PhilipTreacy]

Hi @Anonymous 

Could you please supply your PBIX file or some sample data and examples of your table visual.  Really hard to get my head around this without seeing your data, your measure etc.

regards

Phil