Forum Discussion
Greg_Deckler
5 years agoCommunity Champion
How to Get Your Question Answered Quickly
Ever wonder why some questions get answered so quickly while others languish or are seemingly completely ignored? Fear not, this article will help guide you into getting your question answered quickl...
Faisal0786786
9 months agoNew Member
Show Org (Detox or Favorable) =
Show Org (Detox or Favorable) =
VAR _Detox = [Res Client ID / Detox Client ID]
VAR _Fav = [Favorable Responses %]
VAR _AnyMonthHasValue =
CALCULATE(
COUNTROWS(
FILTER(
VALUES('vwCalendar'[DayDate]),
NOT (
(_Detox = BLANK()) &&
(_Fav = BLANK())
)
)
)
)
RETURN
IF(_AnyMonthHasValue > 0, 1, 0)