Forum Discussion
darshaningale
Resolver II
3 years agoAdd 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 cumulati...
- 3 years ago
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.
darshaningale
Resolver II
3 years agoI 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
Resolver II
3 years agoSpoiler
i have these counts. i need one more count which shows cumulative total.
- rajulshah3 years ago
Resident Rockstar
You can use the following DAX:
Total Count of Host = CALCULATE ( COUNT ( Host[Host] ), ALL ( Host ) )- darshaningale3 years ago
Resolver II
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.