cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Check if column contains specific based on other column grouping

Hallo

 

I am looking for a way to calculate the column "HasSuccess" in the table below given the two other columns "ItemID" and "ItemStatus". If an ItemID has a successful status, I want it to return True and otherwise return False.

 

ItemIDItemStatusHasSuccess
1SuccessTrue
1FailTrue
1SuccessTrue
2FailFalse
2FailFalse
3SuccessTrue
4FailTrue
4SuccessTrue
5FailFalse

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User IV
Super User IV

Re: Check if column contains specific based on other column grouping

Hi @TKLAAB ,

 

You can create a column using DAX expresion as follows:

 

CalcValue =

IF(COUNTROWS(FILTER(ALL(Table), (Table[ItemID] = EARLIER(Table[ItemID])) && Table[ItemStatus] = "Succes")) > 0, "True", "False")
 
In the above DAX replace Table with your tablename.
 
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
 
Thanks,
Pragati

 





If this helps, Appreciate a KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




View solution in original post

4 REPLIES 4
Highlighted
Super User IV
Super User IV

Re: Check if column contains specific based on other column grouping

Hi @TKLAAB ,

 

You can create a column using DAX expresion as follows:

 

CalcValue =

IF(COUNTROWS(FILTER(ALL(Table), (Table[ItemID] = EARLIER(Table[ItemID])) && Table[ItemStatus] = "Succes")) > 0, "True", "False")
 
In the above DAX replace Table with your tablename.
 
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
 
Thanks,
Pragati

 





If this helps, Appreciate a KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




View solution in original post

Highlighted
Super User IX
Super User IX

Re: Check if column contains specific based on other column grouping

@TKLAAB , try as a new column

new column = if(countx(filter(table[ItemID] =earlier(Table[ItemID]) && Table[ItemStatus] = "Success"),table[ItemID)>0,"True","False")



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Highlighted
Helper I
Helper I

Re: Check if column contains specific based on other column grouping

@amitchandak @Pragati11 

Would it be possible to do this as a power query instead?

Highlighted
Super User IV
Super User IV

Re: Check if column contains specific based on other column grouping

Hi @TKLAAB ,

 

In Power Query, you will need to do  a grouping against your ID column. 

Check GROUP BY in Power BI in Edit Query:

https://www.poweredsolutions.co/2019/07/30/grouping-rows-with-power-bi-power-query/

 

Once data is grouped at ID level, you can try creating a IF-ELSE custom column.

 

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

 

Thanks,

Pragati





If this helps, Appreciate a KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors