TOP N and Others in LIVE Connection Type

[BSPAVAN86]

Hi ,

Can anyone advice how to achieve TOP N + others in Power BI with Live Connection (Don’t have option to create calculated columns or Calculated table both are greyed out). Something live below

[v-xiaosun-msft · Accepted solution]

Hi @BSPAVAN86 ,

You can create a measure to get your expected output. I made a sample and please follow these steps.

Sample data:

Create a measure. (Here, my others is "LL Road Frame".)

Measure =
VAR _top3 =
    TOPN (
        3,
        ALL ( 'Product'[Model Name] ),
        CALCULATE ( SUM ( 'Product'[Dealer Price] ) ), DESC
    )
RETURN
    IF (
        HASONEVALUE ( 'Product'[Model Name] ),
        SWITCH (
            TRUE (),
            SELECTEDVALUE ( 'Product'[Model Name] ) = "LL Road Frame", SUM ( 'Product'[Dealer Price] ),
            CALCULATE ( SUM ( 'Product'[Dealer Price] ), KEEPFILTERS ( _top3 ) )
        )
    )

Final output:

Best Regards,
Community Support Team _ xiaosun

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

[amitchandak]

@BSPAVAN86 , I doubt that, in month the approaches you need a table or column, you need get it created in source