Forum Discussion

kelsey_taplin8's avatar
kelsey_taplin8
New Member
1 year ago

Need Help Getting a Card to Show Filtered Down Results and Not Sum

Hello all,

I am struggling with getting a card put together and would love some help. 

 

Our company runs monthly phishing campaigns and wants to track throughout the year employees who are failing the monthly campaigns multiple times and assign them additional trainings. I am trying to create a card to set up an alert for a colleague to be able to get notified when the number of employees who have failed more than once increases so he can review and assign out the training. I'm able to get this all nicely together in a Table using a Total Failure measure and the employees name but since I do not have Fabric or a free trial available at the moment, I can't get the alert to work on the just the table so I'm trying to work around that with a card visual. 

 

My issue though is that the card, KPI, and gauge all sum the total failures within the company and not just within the subsection of employees who failed multiple times.

 

Any suggestions on how to resolve?

Need Help

2 Replies

  • Bipin-Lala's avatar
    Bipin-Lala
    Icon for Solution Sage rankSolution Sage
    1 year ago

    Hi kelsey_taplin8,

     

    If I understand your question correctly, you need a card visual that tracks only the number of employees who failed the phishing campaign multiple times.

     

    For this, you can start by creating a measure to count employees who have failed more than once. Something on the lines of - 

    MultipleFailEmployeeCount = CALCULATE(COUNT(Employee[ID]), FILTER(Employee, [FailureCount] > 1))

     The idea is to basically create a count of employees who have failed more than once.

     

    Then, you can put this value in a card. As you did before, you can set up an alert on the card visual that is triggered when the value crosses a certain threshold.

     

    Thus, you'll be notified when the count of employees failing the phishing campaign multiple times increases. 
    Please Note: The answer may vary depending on the fields, tables, and data you have, so may require a bit more context. But let me know if you have any questions, would be happy to help.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi kelsey_taplin8 ,

     

    Thanks for Bipin-Lala reply, that's really helpful!

     

    kelsey_taplin8 Can you provide a simple data model? Without using fabric capacity, I recommend that you create a custom table and filter out the employees who fail the most, then display the results using multi-row card.

     

    For example.

     

     

     

    Best regards,

    Mengmeng Li