Replicate a chart from excel

[Anonymous]

Hello! I'm trying to replicate a chart from excel which has this:

Where "Tickets" is the amount of items in the chart. When I try to see how its made I see this formula:

"='Cycle Time'!$F$2:$F$115", how can I replicate this chart in power bi? By a count measure maybe?

[Tahreem24]

@Anonymous, You can select the column and select the aggregation type "COUNT" or "SUM" as per your need. Else you can also create a measure seperately for each field.

COUNT MEASURE = COUNT(TableName[Ticket Column])

[Anonymous]

I dont think thats my issue, let me make myself clear, I want down there a value that updates depending on the filters I have and returns the number of tickets that are being filtered.

For example from 1 to 10 or 1 to 100, do I make myself clear?

[v-easonf-msft]

Hi, @Anonymous 

I'm not familiar with excel formulas.

Can you share your sample data and expected results directly? So that I can understand your problem more directly and write the corresponding formulas.

Best Regards,
Community Support Team _ Eason