The problem is that "Distinct Counts" are semi-additive.
The Line Chart applies the calculation for each year, e.g. answers the question for 2018:
In 2018, how many products had a session count greater than 5?
The sum of the Line Chart could potentially be less than the Card if an App had 7 total sessions, but 3 were in 2017 and 4 in 2018 - in that case, the App, which is counted in the Card, would not be counted at all.
In other cases, the sum of the Line Chart could count the same App twice, e.g. it had more than 5 sessions in 2017 and more than 5 in 2018.
Hope this helps,
So in regards to what you explained to me very brilliantly, i believe it would make more sense for the "reader" of the dashboard - if the sum of the line chart correlates with the KPI. This meaning no dublicates that you mentioned could happen
@JacobPBI - So you would only want the App to appear in 2017 or 2018, even though it actually applies for both? Which year would you want it to be included, and which year excluded?
@JacobPBI - I don't understand - The question is: what do you want the value to be for 2017, 2018, 2019, separately, and summed up? Do you want the card to find the value for each of the 3 years, and then add them together?
When i use the slicer (filter) in my report and choose year 2017 i want to get the total sum of 2017 as the KPI but in the line graph i want them to be distributed by month. So when adding all the months together that should match the total sum KPI number. If i filter on 2018 the same story with the total sum in the kpi for 2018, and the total sum distributed by month of 2018. Same story for 2019.
I hope this is better to understand If it is possible to work out it would be much appreciated.
@JacobPBI - You could add the following additional measure, and compare the results between the two. The new measure specifically adds up the values from the months. :
Above5 = COUNTROWS ( FILTER ( SUMMARIZE ( VALUES ( Tabel[AppId] ); [AppId]; "ABCD"; [UniqueSessionsCount] ); [ABCD] > 5 ) )
Above5 Sum Months = COUNTROWS ( FILTER ( ADDCOLUMNS( SUMMARIZE ( Tabel; [AppId]; 'working dates'[RelativeMonth] ); "ABCD"; [UniqueSessionsCount] ); [ABCD] > 5 ) )
Hope this helps,
@natelpeterson Hi Natel - so i understand the issue i am facing - but i still have not been able to solve the problem. The linegraph still shows if a user has been online both months with more than 5 sessions. Is there any way where the app id (in this case) is only counted once even though i filter on multiple months and/or years?