Forum Discussion
Visual filter for a dax measure
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!
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 Team
If 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!