Forum Discussion

ChemEnger's avatar
ChemEnger
Icon for Advocate V rankAdvocate V
6 years ago
Solved

Filter on a measure

Hi,   I feel that this should be simple but my solution isn't working.   I have some records that belong to various departments that have an [Outcome] of either Within Target or Overdue.  I have ...
Need Help
  • az38's avatar
    az38
    6 years ago

    Hi ChemEnger 

    for example, you can try to add a column

    Department has Overdue records = 
var _count = CALCULATE(COUNTROWS(Table), ALLEXCEPT(Table, Table[Department]), Table[Count of Overdue] > 0)
RETURN
IF(_count > 0, TRUE(), FALSE())

    then filter by this column

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

ChemEnger , Try like

countx(filter(summarize(Table,Table[department],"_1",[Count of Overdue] ),[_1]>0),[department])