Forum Discussion
Anonymous
9 years agoNot applicable
Only apply measure to specific rows
Hi,
How would I create a measure that only applies [SAID_FORMULA] to {Specific Channel in Table}.. and applies a different [SAID_FORMULA2] to all else.
Hi Anonymous,
You can do something like this:
FORMULA = IF ( MAX ( Table[Specific Channel] ) = "Specific", SUM ( Table[A] ), SUM ( Table[B] ) )Regards,
MFelix
2 Replies
- MFelix
Super User
Hi Anonymous,
You can do something like this:
FORMULA = IF ( MAX ( Table[Specific Channel] ) = "Specific", SUM ( Table[A] ), SUM ( Table[B] ) )Regards,
MFelix
- AnonymousNot applicable
Perfect!
Thanks!!