Forum Discussion
Visual filter for a dax measure
- Anonymous2 years ago
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!
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