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 ...
Need Help
Tutorial Requests
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)

       

      • Gajo's avatar
        Gajo
        Helper I
        8 years ago

        Hi Eric,

         

        COUNTX(ALLSELECTED(Output),1) gives the total number of rows in the table (754) not the number of selected rows (8)

        MINX(ALLSELECTED(Output),Output[Value]) Gives also the minimum of all 754 rows...

         

        Your image seems to show exactly what I need, but I can't reproduce it in my own file....

        Do you have any other suggestions?

         

        Update: adding a measure iso a column seems to help... Experimenting now...

        How do I use the output of a measure to calculate the next column without haveing the measure switch back to the "all rows" answer? 

         

        Gajo