cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
beginner_help
New Member

IF Statement - Custom Column + Measure

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. 

1 ACCEPTED SOLUTION
v-yangliu-msft
Community Support
Community Support

Hi  @beginner_help ,

I created some data:

vyangliumsft_0-1655802262356.png

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:

vyangliumsft_1-1655802262358.png

 

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

View solution in original post

2 REPLIES 2
v-yangliu-msft
Community Support
Community Support

Hi  @beginner_help ,

I created some data:

vyangliumsft_0-1655802262356.png

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:

vyangliumsft_1-1655802262358.png

 

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
Super User
Super User

Hi @beginner_help 

 

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



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Show Episode 10 Recap

The Power BI Community Show

Watch the playback when Amit Chandak, a Power BI Super User, demos how to use Field Parameters to make reports more dynamic.

Power BI Dev Camp Session 26

New Date - Check it Out!

Mark your calendars and join us on Thursday, October 6 at 11a PDT for a great session with Ted Pattison!

Health and Life Sciences Power BI User Group

Health and Life Sciences Power BI User Group

Power BI specialists at Microsoft have created a community user group where customers in the provider, payor, pharma, health solutions, and life science industries can collaborate.

Top Solution Authors