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

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

        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...

         

        Gajo

        Gajo

        To have a better understanding on your scenario, could you upload the pbix file? You can upload it to Onedrive or any web storage and share the download link. Do note to mask sensitive data before uploading.