Forum Discussion

RafDelgado's avatar
RafDelgado
Helper II
9 years ago
Solved

Measure to filter two seperate tables

Hoping someone can help, I'm working on a report which has two tables which cannot be joined by relationship. The first is a list of server sizes with CPU cores and memory. The second table is also l...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi RafDelgado,

    In your second table, create a measure using the following formula.

    s = IF(HASONEVALUE(t2[CoreCount]),VALUES(t2[CoreCount]),BLANK())

    In  your first table, create a measure using the following formula.
    checkresult = IF(MAX(t1[CPU cores])>=[s]&&MAX(t1[Memory:GB])>=2,1,0)

    Create a table visual shown in the following screenshot. And create a slicer using CoreCount field of second table.


    Set the value of the slicer to 8, then set value of checkresult measure to 1 in visual level filter, you will get expected result.


     


    Thanks,
    Lydia Zhang

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi RafDelgado,

In your second table, create a measure using the following formula.

s = IF(HASONEVALUE(t2[CoreCount]),VALUES(t2[CoreCount]),BLANK())

In  your first table, create a measure using the following formula.
checkresult = IF(MAX(t1[CPU cores])>=[s]&&MAX(t1[Memory:GB])>=2,1,0)

Create a table visual shown in the following screenshot. And create a slicer using CoreCount field of second table.


Set the value of the slicer to 8, then set value of checkresult measure to 1 in visual level filter, you will get expected result.


 


Thanks,
Lydia Zhang

RafDelgado's avatar
RafDelgado
Helper II
9 years ago

Hi Anonymous,

 

Thank you for replying, this is perfect to get me started, I ended up making the changes in the query editor via a column merge but this is so much better.

 

Thanks again :smileyvery-happy:,

 

Raf