Forum Discussion
Resolver IIAdd a cumulative total in line graph
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 |
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.
5 Replies
rajulshahResident Rockstar
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.
- darshaningaleSpoiler
i have these counts. i need one more count which shows cumulative total.