Forum Discussion
Working with filtered data
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...