Forum Discussion
sureshg2498
Advocate II
Advocate IIRemove Aggregation from Matrix visual/Move cell value to front
Hi All, I have created a Matrix visual with customer name under value. Since it aggreagtes i have taken Index to display all customers as shown below. Current Matrix visual Cl...
hI sureshg2498 ,
Please, create a new calculated column by this measure:
Custom Index = VAR CurrentCountry = 'Table'[Country] VAR CurrentQuarter = 'Table'[Fiscal Quarter] VAR CurrentIndex = 'Table'[Index] VAR SortedTable = FILTER ( 'Table', 'Table'[Country] = CurrentCountry && 'Table'[Fiscal Quarter] = CurrentQuarter ) RETURN RANKX(SortedTable, 'Table'[Index], , ASC, Dense)Now, instead to use index in your matrix, please, use Custom index column, and your final result should look like this:
Bibiano_Geraldo
Super User
Super UserhI sureshg2498 ,
Please, create a new calculated column by this measure:
Custom Index =
VAR CurrentCountry = 'Table'[Country]
VAR CurrentQuarter = 'Table'[Fiscal Quarter]
VAR CurrentIndex = 'Table'[Index]
VAR SortedTable =
FILTER (
'Table',
'Table'[Country] = CurrentCountry &&
'Table'[Fiscal Quarter] = CurrentQuarter
)
RETURN
RANKX(SortedTable, 'Table'[Index], , ASC, Dense)
Now, instead to use index in your matrix, please, use Custom index column, and your final result should look like this:
sureshg2498Thank you for your prompt reply to my request for information. I appreciate your quick turnaround on my inquiry. Your speedy response to my information request is much appreciated. Thank you so much Bibiano.
- Bibiano_Geraldo
You're very welcome! I'm glad I could assist you. Thank you for your kind words, and I'm always here to help!
- sureshg2498
Thank you so much.