Forum Discussion

darshaningale's avatar
darshaningale
Icon for Resolver II rankResolver II
3 years ago
Solved

Add 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...
Need Help
  • darshaningale's avatar
    darshaningale
    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's avatar
darshaningale
Icon for Resolver II rankResolver II
3 years ago
Spoiler

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

rajulshah's avatar
rajulshah
Icon for Resident Rockstar rankResident Rockstar
3 years ago

darshaningale 

 

You can use the following DAX:

Total Count of Host =
CALCULATE ( COUNT ( Host[Host] ), ALL ( Host ) )
  • darshaningale's avatar
    darshaningale
    Icon for Resolver II rankResolver II
    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.