Forum Discussion
Helper VOne visualization affected by the filter in another one
Hi Victormar ,
To what I can understand what you want is that a specific visualization overwrites the filter of the Is Latest = 1 and then you can plot your line chart is this correct?
If this is the case you need to use a REMOVEFILTERS, ALL or ALLSELECT in your metric to use in that specific line chart.
Without any data is difficult to give you the correct value for this calculation, but should be similar to something like this:
Total Milage = CALCULATE(sum(Table[Mileage]), REMOVEFILTERS(Table[Is Last]))
Super UserHi Victormar ,
To what I can understand what you want is that a specific visualization overwrites the filter of the Is Latest = 1 and then you can plot your line chart is this correct?
If this is the case you need to use a REMOVEFILTERS, ALL or ALLSELECT in your metric to use in that specific line chart.
Without any data is difficult to give you the correct value for this calculation, but should be similar to something like this:
Total Milage = CALCULATE(sum(Table[Mileage]), REMOVEFILTERS(Table[Is Last]))
VictormarThanks, this is what I was searching for 🙂