Calculating measure based on column groupings

[Anonymous]

Hi everyone!

I'm trying to calculate a measure based on column groupings but unsure how to make it work when aggregated as currently I'm using MIN which won't be correct when aggregated.

IF( MIN([Grouping]) = "Include", IF( [Years] >=1, [logic if true], IF( MIN[Grouping) = "Exclude",  IF( [Years >= 1, [logic if true], [logic if false]))

How can I make this work for the aggregated value?

The data is structured like this

Grouping	Value	Years
Include	123	1
Include	345	1.4
Exclude	123	5.3
Exclude	857	2.3
Exclude	123	6.5

[amitchandak · Accepted solution]

@Anonymous , This type of formula should work

Switch( True() ,
Min([Grouping]) = "Include" && min([Years]) >=1, [logic if true] ,
MIN([Grouping]) = "Exclude" && min([Years]) >= 1 ,[logic if true] ,
[logic if false]
)

[Anonymous]

Thanks!