Forum Discussion
Getting Top 3 values dynamically as there's no Top N filter
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
HI Anonymous,
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
These are standard patterns
1st: TOPN(1)
2nd: TOPN(1,TOPN(2),DESC)
3rd: TOPN(1,(TOPN(3),DESC)
2 Replies
These are standard patterns
1st: TOPN(1)
2nd: TOPN(1,TOPN(2),DESC)
3rd: TOPN(1,(TOPN(3),DESC)
HI Anonymous,
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