count number of occurences in measure

[n00b_90]

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: 

appointment_minutes = DATEDIFF(min(Appointment[Appointment Start Date]);max(Appointment[Appointment End Date]);MINUTE)

How do I count the frequencies of the appointment_minutes, group them by appointment_minutes and display the results in a stacked bar chart?

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

[tex628]

Are you able to calculate the duration as a calculated column instead of a measure? 

/ J

[n00b_90]

@tex628 sorry, forgot to mention that this is a live connection. So, the solution has to be conducted in a measure 🙂 

[tex628 · Accepted 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. 

[n00b_90]

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! 🙂 

[tex628]

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!