Summarize the index

[richard_wylde]

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 unfortunately it is not summarising - do you know if there is a way to get it to summarise ?

Not Summarised

[Anonymous]

Hi  @richard_wylde ,

It is hard to realize as you expect,as measure is an aggregated value,if you dont use another column to split it into detailed rows,it will return only one value.

So,I think your solution is a best one,and it's unavailable to get an aggregated value based on your result.

 
Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[amitchandak]

@richard_wylde , when you group by index, how will group field 1 which is the higher granularity  ?

[richard_wylde]

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]

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]

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]

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]

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