Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Assign a segment to a dax mesure

Hello everyone.

On Power BI I make the ratio between 2 measures.
And I would like to apply a filter via a segment (so that the user can change it easily) except that the segment
applies the filter for the 2 dax measures on the ratio while I would like it to apply only to one of the 2 measures.
I know it is possible to assign a segment to only one visualization, but is it possible to assign it to only one dax measure ?

Thank you !!

Tips and Tricks
  • lbendlin's avatar
    lbendlin
    3 years ago

    you would modify "measure2" to remove the filter that is controlled by that slicer (via REMOVEFILTERS).

7 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    As you can see, I'm making a curve that corresponds to a measure as a function of time. Except that this measure is a ratio, and I would like that when I filter, the filter only applies to "measure1" and not "measure2"

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      3 years ago

      you would modify "measure2" to remove the filter that is controlled by that slicer (via REMOVEFILTERS).

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago
        mesure2 = CALCULATE([blabla1], filter(blabla2, blabla2[blabla3] = "blabla4"), REMOVEFILTERS())
        When i do that, it works but that also delete my filter "blabla4", and i don't want that.
        I tried that : mesure2 = CALCULATE([blabla1], filter(blabla2, blabla2[blabla3] = "blabla4"), REMOVEFILTERS(blabla5[blabla6]))
        Where "blabla5[blabla6]" correspond to the filter i surrounded in red, and it doesn't work i don't know why.
        Thanks for your help