Forum Discussion
Solved
Grouping column values and setting a flag based on another column's value?
I have a large set of data that contains ticket numbers and the history of the Groups the ticket numbers were assigned to. The data may consist of 4 rows for, example, for ticket # 126748, because it...
Hi,
Here is one way to do this:Measure 15 = if(CALCULATE(CONTAINS('Temperature (2)','Temperature (2)'[Temperature],"Warm"),ALLEXCEPT('Temperature (2)','Temperature (2)'[GRP])),1,0)This measure checks if a group contain "Warm" and will return 1 to all rows where this is the case.
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/
ValtteriN
Community Champion
Community ChampionHi,
Here is one way to do this:
Measure 15 = if(CALCULATE(CONTAINS('Temperature (2)','Temperature (2)'[Temperature],"Warm"),ALLEXCEPT('Temperature (2)','Temperature (2)'[GRP])),1,0)
This measure checks if a group contain "Warm" and will return 1 to all rows where this is the case.
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/
You are a genius! This works exactly as I need. Thank you so much!