Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Filter table visual by a slicer

Hi,   I have this table visual, and I want to filter it based on the selected value in the slicer (a package slicer). Example of the table and the table visual is:   No Package Value 1 ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    amitchandak 

    Your equation in the file was really really helpful.

     

    I finally managed to solve the problem using COUNT on "No." column instead of SUM.

    Then used the measure in the filter section, and limited it to equal 1 only.

     

    So, final equation:

     

    Measure2 =

    IF(ISFILTERED(package[package]), CALCULATE(COUNT('Fact'[No]), FILTER('Fact', 'Fact'[Package] IN VALUES(Package[Package]))), CALCULATE(COUNT('Fact'[No]), FILTER('Fact', 'Fact'[Package] in ROW("Package","All Packages"))))
amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , if the tables are disconnected, best option in this case

 

measure =
var _max = if(isfiltered(package[package]), values(package[package]), ROW("package","All Packages"))
return
calculate(sum(Table[Value]),filter(Table, Table[package] in _max))

 

 

if those are connected
measure =
var _max = if(isfiltered(package[package]), values(package[package]), ROW("package","All Packages"))
return
calculate(sum(Table[Value]),filter(package, package[package] in _max), removefilters(package[package]))

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks.

    But this is not the answer to my question.

    I don't want to calculate SUM.

    I want to filter the table visual.

    • amitchandak's avatar
      amitchandak
      Super User
      5 years ago

      Anonymous , Measure has a filter, so if this is the only measure, the visual table will filter. Or all the measures need to follow this type of code

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Thanks.

        But I'm getting errors:

         

         

         

         

         

         

        Mind you that column "Value" is a string column (not numeric). Sorry, but I don't understand what you are summing.

         

        Thanks.