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 , can you share complete formula you created

Anonymous's avatar
Anonymous
Not applicable
5 years ago

My pbix file is very large with many columns and with different column names.

Can you please share the file you created the measures in?

Much appreciated.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      amitchandak 

       

      Thanks a lot.

       

      I checked the file. It works well when data "Value" is of type numeric. My data is actually of type String. ( I should have provided a better working example in my post)

       

      Could you please provide a solution for such type of data?

      Many thanks

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