Forum Discussion

Ayush001's avatar
Ayush001
Microsoft Employee
4 years ago
Solved

How to

# Scenarios in Exception = CALCULATE(IF(Values('Exceptions'[RCATitle])=Blank(),DISTINCTCOUNT('Exceptions'[Remark]),DISTINCTCOUNT('Exceptions'[RCATitle])),Exceptions[SnapshotDate]=MAX('Exceptions'[Sn...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Ayush001 , Try like

     


    CALCULATE(IF( isblank(Max('Exceptions'[RCATitle])),DISTINCTCOUNT('Exceptions'[Remark]),DISTINCTCOUNT('Exceptions'[RCATitle])),
    filter(Exceptions, Exceptions[SnapshotDate]=MAX('Exceptions'[SnapshotDate])))

amitchandak's avatar
amitchandak
Super User
4 years ago

Ayush001 , Try like

 


CALCULATE(IF( isblank(Max('Exceptions'[RCATitle])),DISTINCTCOUNT('Exceptions'[Remark]),DISTINCTCOUNT('Exceptions'[RCATitle])),
filter(Exceptions, Exceptions[SnapshotDate]=MAX('Exceptions'[SnapshotDate])))

  • Ayush001's avatar
    Ayush001
    Microsoft Employee
    4 years ago

    It worked.

     

    Thanks.