Forum Discussion

richard_wylde's avatar
richard_wylde
Icon for Helper IV rankHelper IV
6 years ago

Summarize the index

Hello,   I've created the following simple Matrix  which displays chosen columns based on a slicer choice. Howvever it only works if the index column is included in the matrix. But by doing this un...
Need Help
richard_wylde's avatar
richard_wylde
Icon for Helper IV rankHelper IV
6 years ago

Hi amitchandak ,

 

The result I'd be looking for is below  (the value of the Index field doesn't matter as I'd hide this in the visual )

 

Index    FIELD1      FIELD2
3              D             10
3              C             10

 

Do you know if this is possible ?

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi richard_wylde ，

 

It's really unavailable to achieve what you need:

I can realize as below:

But once I remove index column,it will only show one value:

And columns are fixed values,it cant be changed dynamically.measures without context will be aggregated as one value,in your column col1 and col2,the duplicated values are in different rows ,so it's difficult to write a calculate column to modify the index value,and when you select col 1 or col2 with "Mea" columns,it will run into trouble.

Hope the above make sense.

 

Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!

 

  • richard_wylde's avatar
    richard_wylde
    Icon for Helper IV rankHelper IV
    6 years ago

    Thanks Anonymous ,  I've managed to remove the index column in this example -

     

    https://ufile.io/ikm0v0ci 

     

    but I still have to display all the columns along with the chosen column. Is there no way to display the chosen column & hide the other columns ?

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi richard_wylde ，

       

      Yes,you can ,but you need to "hide" manully,you cant make it happen automatically.

      Go to format,under "column header" and "values",choose :word wrap:off;

       

      And you will see:

       
      Best Regards,
      Kelly
      Did I answer your question? Mark my post as a solution!

       

      • richard_wylde's avatar
        richard_wylde
        Icon for Helper IV rankHelper IV
        6 years ago

        Thanks Anonymous 

         

        Unfortunately it didn't seem to make a differnce, both columns still have to be present in order for either of them to be selected. Is there a way to do it using DAX, as in the example I've added in here -   Example   ?

         

        Thanks