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

Anonymous's avatar
Anonymous
Not applicable
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