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

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