Forum Discussion
Generate Cumulative Count Tooltips over missing inputs
Hi northcity4,
Thank you for reaching out to the Microsoft fabric community forum. Also thanks Greg_Deckler, for his inputs on this thread. I reproduced the scenario, and it worked on my end. I used my sample data and successfully implemented it.
Dax Measure for Cumulative Count:Cumulative Count = VAR CurrentX = SELECTEDVALUE('Dim_X'[Value]) RETURN CALCULATE( SUM('fact_events'[cnt_flag]), FILTER( ALLSELECTED('fact_events'), 'fact_events'[x_value] <= CurrentX ) )
Outcome:I am also including .pbix file for your better understanding, please have a look into it:
Hope this helps clarify things and let me know what you find after giving these steps a try happy to help you investigate this further.
Thank you for using the Microsoft Community Forum.
northcity4 You can write a cumulative measure for the tooltip but it won't display for values of x that don't exist I don't believe. You just add the measure to the Tooltips field well or you could create your own custom tooltip page. Might also try with x-axis being categorical or continuous.
Thanks for taking a look! The link was quite interesting to review, but I think the suggestions there and your other options did not get me the result I was hoping for. Perhaps they can add an "interpolation" option in a future update to have more display options and display functionality for areas with missing data, such as the built-in tooltip mechanic.