Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 values. But it looks like my DAX formula is wrong and it's calculating the median for the entire table and not per category.
For Eg, The median value for $100K-$150K group for 'CD' category should be 36, but its showing 270 on the bar chart.
My sample data:
count | SC | Deposit Balance Group |
20 | CD | GT $2M |
18 | CD | $150K-$200K |
12 | CD | $200K-$250K |
42 | CD | $200K-$250K |
17 | CK | $100K-$150K |
11 | CK | $100K-$150K |
11 | CK | $100K-$150K |
17 | CK | $100K-$150K |
47 | CK | $100K-$150K |
The DAX measure I created:
Measure =
MEDIANX (
SUMMARIZE (
Sheet1,
Sheet1[SC],
"Total Count", SUM ( Sheet1[count] )
),
[Total Count]
)
Please let me know how can I overcome this situation.
Thanks
I've attached the pbix file which has the complete data and measure formula: pbix file
Solved! Go to Solution.
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
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
User | Count |
---|---|
25 | |
12 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
12 | |
11 | |
9 | |
6 |