Forum Discussion

SearchKnowledge's avatar
SearchKnowledge
Icon for Helper I rankHelper I
5 years ago
Solved

Combine values from visuals into a total visual

Hello kind reader,   The situation is like this: I have two table visuals: Bothe tables contain different columns and different date filters, however they have 1 column which is the same: The prod...
Need Help
  • SearchKnowledge's avatar
    SearchKnowledge
    5 years ago

    mahoneypat Anonymous 
    I have found a solution: It was to put the function ALL('Date') into the measures i didnt want to be affected by the slicer. And then with Daterange() i could set the static date range. 

    Thanks you all for thinking with me!

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

You can harvest to two filter dates in variables in a new measure and then use them both in the filter of the calculation.  For example,

 

NewMeasures = var vSlicer1Date = SELECTEDVALUE(Slicer1[Date])

var vSlicer2Date = SELECTEDVALUE(Slicer2[Date])

return CALCULATE([YourMeasure], Table[Date] = vSlicer1Date || Table[Date] = vSlicer2Date)

 

Regards,

Pat