Forum Discussion

nabila97's avatar
nabila97
New Member
4 years ago
Solved

Facing problems to measure this problem

Hi,   Data given:  Date of Case Type of Case 19-Apr-20 Process 19-Apr-20 Process 19-Apr-20 Process 21-Jun-20 Non Process 22-Jun-20 Non Process 25-Jul-21 Process 25-J...
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    4 years ago

    nabila97 

    Try this measure.

    No of Cases = 
SUMX ( 
    VALUES ('Table'[Type of Case]),
    CALCULATE(DISTINCTCOUNTNOBLANK('Table'[Date of Case]))
)

     

jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
4 years ago

nabila97 

Try this measure.

No of Cases = 
SUMX ( 
    VALUES ('Table'[Type of Case]),
    CALCULATE(DISTINCTCOUNTNOBLANK('Table'[Date of Case]))
)