Forum Discussion
problem with multiple selection in sumx
Please follow the link. It has the exact solution for you. I tried it on the pbix file you uploaded. It worked perfectly.
http://sqljason.com/2017/03/dynamic-grouping-in-power-bi-using-dax.html
If it works for you pleasse accept this as solution and also give KUDOS.
Cheers
CheenuSing
follows the file, as I had said, with simple selection works perfectly. It brings the selected customer into one column and groups the other clients into the "other" column of the chart. I need to select two clients, example (D and C) and the graph presents these three columns (D, C and one of Others)
Hi LeandroCorrea,
The difficult is how to change the part where the selection is multiple, there will be some values compared to some values in this part: FILTERS( table2[Cliente]) = FILTERS(Auxiliar2[Cliente]).
Usually we use slicer to affect the chart directly. It affects measure in your chart. While use the slicer filter the x-axis directly, the Outros is not including in slicer, so it's hard to find a workaround. I will post the update if I find solution.
Best Regards,
Angelia