Most popular from Dataverse

[Kosenurm]

Hi there, 

I have a desk booking app, and the desks which have been booked are in a Dataverse table column. 

I want to show a simple data card which counts the amount of times each individual desk reference appears in this column, and only shows the top result (the one with the most bookings). 

Any ideas how I can do this?

Thanks

K.

[Kosenurm]

Thanks, but when I do this, I get this error message - any ideas?

Error Message:
OLE DB or ODBC error: [DataSource.Error] Microsoft SQL: Input query length exceeding the supported maximum length.

[v-xiaotang · Accepted solution]

Hi @Kosenurm 

Step1: connect to dataverse in Power BI Desktop,

Connect to Dataverse from Power BI Desktop

Step2: After get data from dataverse, create measures like bellow( I create a sample for your reference, see file attached bellow)

count = COUNT('Table'[desk])

MaxCount =
VAR _count =
    MAXX ( 'Table', [count] )
VAR _name =
    CALCULATE ( MAX ( 'Table'[desk] ), FILTER ( 'Table', [count] = _count ) )
RETURN
    _name & UNICHAR ( 10 ) & _count

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.