The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi
I am trying to create a list of rows which are ranked in the top 10 in all three lists shown in the screenshot.
I have tried without any success to use Top N on one of the measure "CFC" which i the first column in th screenshot.
This actually works if I refer to a column but not a measure.
Top id of CFC = IF( 'jiradb changeitem'[ID] >= MINX(TOPN(10; 'jiradb changeitem'; [CFC]);'jiradb changeitem'[ID]) && 'jiradb changeitem'[ID] <= MAXX(TOPN(1; 'jiradb changeitem'; [CFC]);'jiradb changeitem'[ID]
);'jiradb changeitem'[ID];BLANK())
So, again if a Name is present in the top 10 of all three column (or in some cases only two columns) it qualifies to be shown in the Combine Top 10 list.
Any suggestions?
User | Count |
---|---|
16 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
26 | |
13 | |
12 | |
8 | |
8 |