Power BI - DAX Query

Hello Heinrich 

try this

DEFINE

    VAR __DS0FilterTable =

        FILTER(

            KEEPFILTERS(VALUES('CQD'[PSTN Trunk FQDN])),

            NOT('CQD'[PSTN Trunk FQDN] IN {"sbc02-id.axa.co.id"})

        )

    VAR __DS0Core =

        FILTER(

            SUMMARIZECOLUMNS(

                'CQD'[PSTN Trunk FQDN],

                "SumTotal_Stream_Count", CALCULATE(SUM('CQD'[Total Stream Count])),

                "SumPSTN_NER_Good_Percentage", CALCULATE(SUM('CQD'[PSTN NER Good Percentage]))

            ),

            [SumPSTN_NER_Good_Percentage] < 100

        )

    VAR __DS0PrimaryWindowed =

        TOPN(501, __DS0Core, 'CQD'[PSTN Trunk FQDN], 1)

EVALUATE   

    SELECTCOLUMNS(

        __DS0PrimaryWindowed,

        "SBC", 'CQD'[PSTN Trunk FQDN],

        "NER", [SumPSTN_NER_Good_Percentage],

        "TOTAL STREAM", [SumTotal_Stream_Count]

    )

ORDER BY

    "SBC"

Thanks,
 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.