Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Conditional range with a measure

Hi everybody, 

 

I have a small issue.. I would like to create a graph with a range that changed when I clicked on a filter. To do that, I created a measure to count something, the value of this measure changed when I clicked on a filter. So I thought that to change the range, I just have to put this measure in the next conditional element. 

But it doesn't works, do you have an idea of how I could do my wish ? 

Thank you in advance !

Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    3 years ago

    Sorry everybody, my explanations were very bad. I found the error and hopefully, I succeded to solve it. It was a filter's issue and not about measure. So I was a bit confused and stupid at the same time but now, it works ahah. 

    Thanks to everyonne who tried to help me. 

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Sorry everybody, my explanations were very bad. I found the error and hopefully, I succeded to solve it. It was a filter's issue and not about measure. So I was a bit confused and stupid at the same time but now, it works ahah. 

    Thanks to everyonne who tried to help me. 

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    Anonymous , Assume you have measure M1 used as value of visual and Column C1 is on Axis

     

    Max = MAxx(Values(Table[C1]) ,[M1]) *1.1

     

     

    Min= Minx(Values(Table[C1]) ,[M1]) *.9

     

    you can use above measures in min/max in fx

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      It doesn't works, but since yesterday, I found the "error". If I use the fonction "calculate", the measure don't recognize that it's a number. But I have to use this function to apply a filter on the measure. I think it's not very clear but if you have a solution, I will take it