Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
erhine1204
New Member

How to calculate a running total of Vulnerabilities?

Hello,

 

For the life of me I cannot figure out how to create a running total trend line of vulnerabilities from my organizations Fortify SAST tool. Below is an example of the data that I am currently exporting into Excel. What I am trying to do is show a running total of vulnerabilities by Severity at an enterprise level for all applications, and then at an individual application level. I would also create trend lines for OWASP status, Developer Status, etc.

 

Example Data

Vuln IDSeverityStatusDeveloper StatusIntroduced DateOWASPApplicationIDReleaseIDCategory
1CriticalFix ValidatedWill Not Fix1/2/2018A11234521212Injection
2CriticalNewWill Not Fix2/6/2019A21234521212Session Mgmt

3

CriticalExistingOpen2/12/2019A232165321321Session Mgmt
4CriticalExistingOpen5/8/2020A332165654654Privacy Violation
5HighNewOpen12/1/2020A9111116546543rd party
6MediumRe-OpenedIn Progress1/16/2021A9111112121213rd party
7LowExistingIn Progress2/3/2021A112345321321Injection

 

I have been able to create the trend line data I am looking for with Excel formulas by running a count of every status every week. Here is an example of the data and trend that I am trying to reproduce in Power BIextrend.png

Any help on this would be greatly appreciated.

 

Thank you,

 

Eric

1 REPLY 1
dedelman_clng
Community Champion
Community Champion

Hi @erhine1204  - 

 

Try this code for your running count:

Running Total =
CALCULATE (
    COUNTROWS ( Vulnerabilities ),
    ALLSELECTED ( Vulnerabilities ),
    FILTER ( ALLSELECTED ( DateTab[Date] ), DateTab[Date] <= MAX ( DateTab[Date] ) )
)

This assumes you have a Calendar table linked to Vulnerabilities based on "Intorduced Date".

 

If this doesn't work, please share DAX that you have tried and/or a copy of your PBIX with sensitive data removed (link to google drive, OneDrive, dropbox, etc)

 

Hope this helps

David

 

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.