Forum Discussion
Working with filtered data
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 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
Then what is wrong with ALLSELECTED? You mentioned that ALLSELECTED doesn't work.
ValueMin = MINX(ALLSELECTED(Table1),Table1[value]) MVM = COUNTX(ALLSELECTED(Table1),1)
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
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
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.
Ok One step further:
BINS and ValueRange are measures that are changed depending on the data that's selected.
These are then used to calculate the BinNum column, but now this is again using the unfiltered data.
How can I prevent this? A measure won't work because I need to calculate a value for every column...
Gajo
BinNum should be -8 -8 -8 -7 -7 -6 -8 -6
Added an extra column: Test = [ValueRange]
ValueRange is clearly 8 as can be seen in the table below, but the Test column is 31 and I don't understand why...