Forum Discussion
Generate Cumulative Count Tooltips over missing inputs
- 1 year ago
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.
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.
Hi v-kpoloju-msft,
Thanks for looking into this! I see now that the x-axis needed to stem from Dim_X.