Our training courses

Other training resources

Our training venues

Why we are different

Details for Stefan

Stefan has participated in the following threads:

Added by Stefan on 29 Oct 2024 at 13:17

It could be also implemented like this probably? =>

Ranking Other Option =

var tabSeries =

    all(

        Series[Series]

    )

var vViewers = SELECTEDVALUE(Series[Viewers (m)])


return

    /*

    CONCATENATEX(

        tabSeries

        , [Series] & " - " &  var mySeries = [Series] return calculate(sum(Series[Viewers (m)]), REMOVEFILTERS(), Series[Series] = mySeries)

        , UNICHAR(10)

        , var mySeries = [Series] return calculate(sum(Series[Viewers (m)]), REMOVEFILTERS(), Series[Series] = mySeries)

        , ASC

    )

    */

   

    rankx(

        tabSeries


        , var mySeries = [Series] return calculate(sum(Series[Viewers (m)]), REMOVEFILTERS(), Series[Series] = mySeries)

        , vViewers


        , ASC

    )

   

Head office

Kingsmoor House

Railway Street

GLOSSOP

SK13 2AA

London

Landmark Offices

99 Bishopsgate

LONDON

EC2M 3XD

Manchester

Holiday Inn

25 Aytoun Street

MANCHESTER

M1 3AE

© Wise Owl Business Solutions Ltd 2024. All Rights Reserved.

End of small page here
Please be aware that our website uses cookies!
I'm OK with this Tell me more ...