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 screenshot for more datails.
Location information form location table employee info from MIE table (relation many to one cross filter both dirction ) please help thank you.

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.

2 Replies