Forum Discussion
plot median value for selected category
I'm trying to plot the median value of counts for 'SC' category based on selection of 'deposit balance group' category on a bar chart. I created a measure using DAX which can calculate the median val...
Hi Anonymous -
You're over-thinking it 😊. By doing a Summarize you are totalling all of the counts and then performing MEDIAN on a single value. You would do something similar if you needed to count up the records from raw data, but since you already have the counts, all your measure needs is MEDIAN()
Hope this helps
David
dedelman_clng
Community Champion
Community ChampionHi Anonymous -
You're over-thinking it 😊. By doing a Summarize you are totalling all of the counts and then performing MEDIAN on a single value. You would do something similar if you needed to count up the records from raw data, but since you already have the counts, all your measure needs is MEDIAN()
Hope this helps
David