Forum Discussion
Visual filter for a dax measure
Hello,
I have a doubt about a basic thing that I really feel as important thing to use. I am talking about having a slicer based in a dax measure which allows me to filter some data.
I created a basic example in this picture where we can see a different amount depending the person aggregated by year.
What I would like to be able is to create a slicer about the measure 'Quantity' which is the sum of the column 'Amount'.
We know that the use of 'Amount' as a slicer is not the proper one because, in fact, it is giving the option to filter by the amount by rows.
What I am looking for is a slicer where we can have a range from 222 to 379 or 0 to any amount where we can exclude for example to 'Rose' from the graph if the minimum value in the slicer is above 222.
Thank you in advance!
Hi jmateu88 ,
Ritaf1983 , thanks for your concern about this case. I tried to create a sample data myself based on the user's requirement. Please check if there is anything that can be improved. Here is my solution:
1.Create a simple data:
2.Create a calculated column:
Column = CALCULATE(SUMX('Table','Table'[Quantity]),ALLEXCEPT('Table','Table'[ID]))3.Use the Column as the field of slicer:
4.The final results are as follows:
Best Regards,
Zhu
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
4 Replies
Hו jmateu88
Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
Hi jmateu88 ,
Ritaf1983 , thanks for your concern about this case. I tried to create a sample data myself based on the user's requirement. Please check if there is anything that can be improved. Here is my solution:
1.Create a simple data:
2.Create a calculated column:
Column = CALCULATE(SUMX('Table','Table'[Quantity]),ALLEXCEPT('Table','Table'[ID]))3.Use the Column as the field of slicer:
4.The final results are as follows:
Best Regards,
Zhu
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!Hello Anonymous and thank you for the right answer.
I was expecting something different in order to not make dirty the table but, the code has sense and it is totally correct.Thank you very much!
