cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
acg
Resolver I
Resolver I

Top 10 numbers called by duration of call

Just adding another post to clarify what I need.

Basically, I want this sql query translated into DAX:

 

SELECT TOP 10 To_Person,
Max(Call_Duration) as longest_call_duration

FROM [table]
where [date]= '2020-05-30'
group by
To_Person, Call_Duration

 

I Calculated Max Duration in Power BI like: 

Max Duration = Max('table'[Call_Duration])
 
Then used the slicer, added to_Number and used TopN 
by Max_Duration
 
But I do not get the same results. 
THere are no other filters in the slicer except for the date as in '2020-05-30'
 
Any ideas how this can be solved?
1 REPLY 1

Hi @acg 

 

Can you share a sample of your data here? do you want to create a table with to_Number column and just max10 duration?

 

You can add a RANK to your duration then filter that to 10.

 

Appreciate your Kudos✌️!!

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors