Forum Discussion
Resolver IIAdd a cumulative total in line graph
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.
Resident Rockstardarshaningale
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.
Resolver III 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.
- rajulshah
You can use the following DAX:
Total Count of Host = CALCULATE ( COUNT ( Host[Host] ), ALL ( Host ) )- darshaningale
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.