Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi!
I am totally lost in how to count number of occurences in a measure and display it in a stacked bar chart.
I have a result that looks like this:
Appointment_minutes is based on this measure:
I am new to Power BI, so there might be a pretty simple and straight forward solution that I can't think of..
Hope somebody can help me! 🙂
Kind regards,
S
Solved! Go to Solution.
360 = COUNTROWS( FILTER( SUMMARIZE( Table1, Table1[start time], Table1[end time], "Value" , [duration measure] ), [Value] = 360 ))
Try this and make one for each potential duration.
Are you able to calculate the duration as a calculated column instead of a measure?
/ J
@tex628 sorry, forgot to mention that this is a live connection. So, the solution has to be conducted in a measure 🙂
360 = COUNTROWS( FILTER( SUMMARIZE( Table1, Table1[start time], Table1[end time], "Value" , [duration measure] ), [Value] = 360 ))
Try this and make one for each potential duration.
Thank you @tex628 ! I actually had over 75 distinct appointment durations so i crated a calculated column in the cube where i categorized the columns into 9 values, the 9th being "More than 2 hours". I combined the switch and datediff function.
Then i used your measure in Power BI and it works! 🙂
You will need to create a measure for each potential duration, that counts the amount of occurances for that duration. Then you all of these measures together in the value section of the chart!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |