Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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 retu...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
6 years ago

Hi Anonymous ,

 

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