Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
Solved! Go to 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.
@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.
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.
i have these counts. i need one more count which shows cumulative total.
You can use the following DAX:
Total Count of Host =
CALCULATE ( COUNT ( Host[Host] ), ALL ( Host ) )
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.
User | Count |
---|---|
93 | |
85 | |
78 | |
68 | |
62 |
User | Count |
---|---|
113 | |
99 | |
96 | |
64 | |
58 |