Forum Discussion
Filter on a table
I need help;
I have a matrix and I want only the 10 lines that have the most value to appear to me; as long as those Items don't appear in another table.
Table 1 Table 2
Item Item Value
1 1 10000
2 5 100000
3 4 8000
4 6 100000
I want only values that are not in Table 1 to appear in table d; and that only the 20 that have a higher value appear.
Deputy Pbix; with real data; where table1 is Billing and Table 2 is Alq Orders,
https://drive.google.com/file/d/1wcjIvxpX4UYDb4SL6AEhNwNDtFpsSaQ0/view?usp=sharing
Thank you
Hi nuriac ,
Check the measures.
Measure = IF(ISBLANK(CALCULATE(MAX(TableB[id]),FILTER(TableB,TableB[id]=SELECTEDVALUE(TableA[id])))),SELECTEDVALUE(TableA[value]),BLANK()) Measure 2 = RANKX(ALLSELECTED(TableA),[Measure],,DESC)The first measure filters the ids in tableB.
The second measure rank the ids not in tableB.
Add the measure2 to visual filter and the result would be shown as below.
Best Regards,
Jay
3 Replies
you can probably create a measure using RANKX and TOPN to set an inclusion flag. Have you tried writing a measure ?
The attached PBIX does not contain either of these tables.
Hi, excuse me, it was an example.
I want the sheet table ordered alq; Take only the 10 highest-amount tabs, and these tabs are not in the table in the billing blade table at the same time.
I have no idea what I need to do to get it.
https://drive.google.com/file/d/1wcjIvxpX4UYDb4SL6AEhNwNDtFpsSaQ0/view?usp=sharing
https://drive.google.com/file/d/1wcjIvxpX4UYDb4SL6AEhNwNDtFpsSaQ0/view?usp=sharing
Hi nuriac ,
Check the measures.
Measure = IF(ISBLANK(CALCULATE(MAX(TableB[id]),FILTER(TableB,TableB[id]=SELECTEDVALUE(TableA[id])))),SELECTEDVALUE(TableA[value]),BLANK()) Measure 2 = RANKX(ALLSELECTED(TableA),[Measure],,DESC)The first measure filters the ids in tableB.
The second measure rank the ids not in tableB.
Add the measure2 to visual filter and the result would be shown as below.
Best Regards,
Jay
