Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
Solved! Go to 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 , 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]
)
Thanks!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
117 | |
101 | |
71 | |
61 |