Forum Discussion

nuriac's avatar
nuriac
Helper III
5 years ago
Solved

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 ...
  • Anonymous's avatar
    Anonymous
    5 years ago

    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

lbendlin's avatar
lbendlin
Super User
5 years ago

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.