Forum Discussion

Gajo's avatar
Gajo
Helper I
8 years ago

Working with filtered data

I have a table with some columns with indexes and 1 column with data.

When I use a slicer to select some of the indexes I see the selected data in a line chart and in a table on my page.

 

How do I calculate the minimum of the selected data in the table? I either get the minimum of the total unfiltered table or I get a different answer in every selected row when I use ALLSELECTED.

 

Any help would be greatly apreciated.

 

Gajo

Need Help
Tutorial Requests

9 Replies

  • Eric_Zhang's avatar
    Eric_Zhang
    Microsoft Employee
    8 years ago
    Gajo wrote:

    I have a table with some columns with indexes and 1 column with data.

    When I use a slicer to select some of the indexes I see the selected data in a line chart and in a table on my page.

     

    How do I calculate the minimum of the selected data in the table? I either get the minimum of the total unfiltered table or I get a different answer in every selected row when I use ALLSELECTED.

     

    Any help would be greatly apreciated.

     

    Gajo

    Gajo

    Where do you use the min measure? In a card visual, just

    Measure = MIN(Table1[Column3])

     

     

    For further advice, please post some sample data and expected output in your case.

    • Gajo's avatar
      Gajo
      Helper I
      8 years ago

       Dear Eric,

       

      Thanks for your feedback.

      What I need is the follwwing: 

      The table below shows the selected data (8 out of about 500 rows)

      How do I get the MVM column to say the number of rows (8) in stead of the number of rows in the slicer (11)

      VualueMin should then be -78.33 in all rows...

       

      Any idea if this is possible?

       

      Gajo 

       

       

       

      • Eric_Zhang's avatar
        Eric_Zhang
        Microsoft Employee
        8 years ago
        Gajo wrote:

         Dear Eric,

         

        Thanks for your feedback.

        What I need is the follwwing: 

        The table below shows the selected data (8 out of about 500 rows)

        How do I get the MVM column to say the number of rows (8) in stead of the number of rows in the slicer (11)

        VualueMin should then be -78.33 in all rows...

         

        Any idea if this is possible?

         

        Gajo 

         

         

         

        Gajo

        Then what is wrong with ALLSELECTED? You mentioned that ALLSELECTED doesn't work.

         

        ValueMin = MINX(ALLSELECTED(Table1),Table1[value])

MVM = COUNTX(ALLSELECTED(Table1),1)