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
Gajo's avatar
Gajo
Helper I
8 years ago

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

Gajo's avatar
Gajo
Helper I
8 years ago

Is there anyone who can help me with this problem?

  • Gajo's avatar
    Gajo
    Helper I
    8 years ago

    Am I asking the impossible here or is there just noone who knows the awnser?

    As a novice it looks to me that it shoudn't be this hard to add or subtract two numbers in a table...

  • Gajo's avatar
    Gajo
    Helper I
    8 years ago

    I ask again: Is there anyone who knows how to combine calculated measures and columns??