Forum Discussion

nabila97's avatar
nabila97
New Member
4 years ago
Solved

Facing problems to measure this problem

Hi,

 

Data given: 

Date of CaseType of Case
19-Apr-20Process
19-Apr-20Process
19-Apr-20Process
21-Jun-20Non Process
22-Jun-20Non Process
25-Jul-21Process
25-Jul-21Process
25-Jul-21Process
23-Aug-21Process

 

how to create measure for this data to get like data below:

 

Type of CaseNo of case (*for same date - calculate as 1)
Process3
Non-Process2

 

Thank you.

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]))
)

     

1 Reply

  • 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]))
)