Top N for all charts and filters

DAX DAX Calculations
1

Hi there,

Is there a way to show the Top N of all the charts and filters on a page? I welcome any M Language options/combinations as well.

Thank you!

TopN.zip (66.9 KB)

2

bumping this post

3

Hello @powerbideveloper

Thank you posting your query in the forum.

I have created the Rank Price measure now based on your selection all the visual will gets filtered, you can replace the [Total Price] measure with [Total Budget] and [Total Cost] in the Price_TopN to get the same.

I’m also attaching the solution PBIX file for your reference.
TopN_Dharma.pbix (53.5 KB)

image
image969×684 26.2 KB

Measure -
Price_TopN =

VAR _Seletedvalue = SELECTEDVALUE(‘Top N’[Top N])

VAR _Rankx_Product = RANKX(ALL(‘Product’[Product]), [Total Price], , DESC)

VAR _Rankx_Country = RANKX(ALL(County[County]), [Total Price], , DESC)

VAR _Rankx_SalesPerson = RANKX(ALL(‘Sales Person’[Sales Person]), [Total Price], , DESC)

VAR _Rankx_Customer = RANKX(ALL(Customer[Customer]), [Total Price], , DESC)

VAR _Condition =

            SWITCH(TRUE(),

            ISINSCOPE('Product'[Product]),

            IF(_Rankx_Product<=_Seletedvalue,[Total Price],BLANK()),

            ISINSCOPE(County[County]),

            IF(_Rankx_Country<=_Seletedvalue,[Total Price],BLANK()),

            ISINSCOPE('Sales Person'[Sales Person]),

            IF(_Rankx_SalesPerson<=_Seletedvalue,[Total Price],BLANK()),

            ISINSCOPE(Customer[Customer]),

            IF(_Rankx_Customer<=_Seletedvalue,[Total Price],BLANK()))

Return

_Condition

2 Likes
4

Hi @powerbideveloper, did the response provided by @Dharma help in solving your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query.

5

@Dharma

Sorry for the delay, I will check this out and get back to you today.