Forum Discussion

ahipon's avatar
ahipon
Frequent Visitor
4 years ago

Using results from filtering to filter another visual

I have a matrix visual with material in rows and Year Week in columns.  The values essentially show a running total with numbers that are positive, negative or zero.      For any given Year ...
amitchandak's avatar
amitchandak
Super User
4 years ago

ahipon , Simply filter measure < 0 should work in this case as the combination is material and week

 

Other wise we need create measure at that level and filter using allexcept , allselected/,max etc

ahipon's avatar
ahipon
Frequent Visitor
4 years ago

Thanks for the suggestion.  Filtering for just measure < 0 doesn't quite work because I also need to be able to choose which Year Week to view. 

 

When also filtering Year Week I get the correct Materials but I want to see all the Week Year columns.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    HI ahipon,

    Can you please share a pbix or some dummy data that keep raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

    How to Get Your Question Answered Quickly  

    Regards,

    Xiaoxin Sheng

    • ahipon's avatar
      ahipon
      Frequent Visitor
      4 years ago

      Hi Xiaoxin,

      Below is sample pbix file with dummy data.

      https://drive.google.com/file/d/1nVQDN_xLsl3MPWcFFKKgOCVa32xXnKMY/view?usp=sharing

      There is a simple matrix with values from a measure that is working correctly.  There are are negative and positive values.  Currently all Materials are displayed.  I would like to dynamic pick a YearWeek, determine what Materials where value is negative, then filter entire Matrix based on the list of Materials.

      Thank you.