Add a cumulative total in line graph

[darshaningale]

I have the below sample data to be shown in line chart.

I am able to show the count of Hostname with respect to Type in line chart.

However i want to show one more line which will show the cumulative of all the sum of counts.

Host	Type	Date
20.164.249.166	Low	3/25/2023
20.164.176.76	Medium	2/13/2021
20.164.192.126	Medium	7/22/2022
20.164.246.8	Medium	5/8/2021
20.164.246.82	Critical	4/7/2023
20.164.192.50	Low	4/1/2020
10.8.0.42	Critical	3/22/2023
20.164.246.7	Medium	9/24/2020
20.164.253.10	Critical	4/8/2023
20.164.184.98	Critical	3/16/2023
20.164.180.118	High	4/24/2020
20.164.180.143	High	4/24/2020

[rajulshah]

@darshaningale 
Please create a measure using the below DAX function:

Total Count of Host =
CALCULATE ( COUNT ( Host[Host] ), ALL ( Host[Type] ) )

You would get the following output:

Please let me know if this didn't work.

[darshaningale]

I also want to show count of each Type in the line graph.

So there would be one line each for "High" ,"Medium", "Critical" , "Low" in addition to cumulative total.

[darshaningale]

Spoiler

i have these counts. i need one more count which shows cumulative total.

[rajulshah]

@darshaningale 

You can use the following DAX:

Total Count of Host =
CALCULATE ( COUNT ( Host[Host] ), ALL ( Host ) )

[darshaningale · Accepted solution]

I have created seperate measures of each "Type" and also created one measure for Cumulative total and added all the measures in the line chart.

Instead of using the "Type" in Legend section.