Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Parsing filter methods

Hello   1) I generated Table1 with a series: 1 2 etc   2) I put the above series to a slicer visual so that the user can choose any combination of values eg. 1, 3, 5, etc.   3) I want to use...
General Comment
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    I suggest you to try to create a measure to filter your visual. I think there should be no relationship between Table1[Col1] and Table2[Col1].

     

    Measure = 
VAR _MAX_COL1_TABLE1 = MAX(Table1[Col1])
RETURN
IF(SUM(Table2[Col1])<_MAX_COL1_TABLE1,1,0)

     

    Add this measure into the visual level filter and set it to show items when value =1.

    Result is as below.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.  

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ,

 

I suggest you to try to create a measure to filter your visual. I think there should be no relationship between Table1[Col1] and Table2[Col1].

 

Measure = 
VAR _MAX_COL1_TABLE1 = MAX(Table1[Col1])
RETURN
IF(SUM(Table2[Col1])<_MAX_COL1_TABLE1,1,0)

 

Add this measure into the visual level filter and set it to show items when value =1.

Result is as below.

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.