Getting Top 3 values dynamically as there's no Top N filter

[HaveeshPerla_1]

Hi Team,

I'm building a report related to Citrix workspaces. In which, I've made visuals which would be sagregated based on versions. Latest versions as =>23, Versions = 22, lower Versions as<= 21. All these values have been give through filters as a static approach.

But There's a requirement where, if the versions have been updated to some 28 , 27 and 26. these versions have to be dynamically updated by replacing the above mentioned values.  I thought of trying Top N flter. But there's no Top N option showing to my versions column. So, how do I acheive this dynamically?

Regards,

Haveesh

[v-shex-msft · Accepted solution]

HI @HaveeshPerla_1,

You can write measure expression to use Dax functions get the max value of versions, and use it as condition in Dax expression to compare with records and return flag.

After these steps, you can use it on 'visual level filter' to filter records.

Applying a measure filter in Power BI - SQLBI
Regards,

Xiaoxin Sheng

[lbendlin · Accepted solution]

These are standard patterns

1st:  TOPN(1)

2nd: TOPN(1,TOPN(2),DESC)

3rd: TOPN(1,(TOPN(3),DESC)

[v-shex-msft · Accepted solution]

HI @HaveeshPerla_1,

You can write measure expression to use Dax functions get the max value of versions, and use it as condition in Dax expression to compare with records and return flag.

After these steps, you can use it on 'visual level filter' to filter records.

Applying a measure filter in Power BI - SQLBI
Regards,

Xiaoxin Sheng