Forum Discussion

VenkateshLanka's avatar
VenkateshLanka
Regular Visitor
3 years ago
Solved

Multiple Incident employee count based on selected date range.

Hello, I am looking for multiple incident employee count based on selected date range. Deacription : - If any employee involved more then once incident in year need show, please see the below scree...
Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    3 years ago

    Hi VenkateshLanka ,

    According to your description, here's my solution.

    Sample:

    Create a measure:

    Measure =
VAR _count =
    CALCULATE (
        DISTINCTCOUNT ( 'Table'[Incident Category] ),
        ALLSELECTED ( 'Table' )
    )
RETURN
    IF ( _count > 1, MAX ( 'Table'[Incident Category] ), BLANK () )

    Get the correct result:

    I attach my sample below for your reference.

     

    Best regards,

    Community Support Team_yanjiang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
3 years ago

Hi VenkateshLanka ,

According to your description, here's my solution.

Sample:

Create a measure:

Measure =
VAR _count =
    CALCULATE (
        DISTINCTCOUNT ( 'Table'[Incident Category] ),
        ALLSELECTED ( 'Table' )
    )
RETURN
    IF ( _count > 1, MAX ( 'Table'[Incident Category] ), BLANK () )

Get the correct result:

I attach my sample below for your reference.

 

Best regards,

Community Support Team_yanjiang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.