Measre in Matrix Column

[kongyuancn]

Hi There,

I have simple table:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("NY45EsJAEMT+MrGDHd8OAYNP+MCW//8NNNAbqKrVkXI2t8pu4CnZVWWr2Xeo5Q37AY28Zc/Qyjv2Ezp5z35BLx/YCwzykb3CKJ/YG0xyT8j+D9ITiUc8pdEj8oynVHpkvuMpnR6hn3h+pdcX", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [ID = _t, Name = _t, Value = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"ID", Int64.Type}, {"Name", type text}, {"Value", Int64.Type}})
in
    #"Changed Type"

It looks like as followings:

Then I made a matrix, which looks like:

Row is the Names and Column is the IDs. And I use a slicer to filter what ID I want.

Then I get a request: User want to use a simple index (1,2,3,4) on the column instead of ID. Whatever the IDs are, he want the index is always starts from 1.

Then I create a measure:

ID to Index = RANKX(ALLSELECTED('Table'), CALCULATE(MAX('Table'[ID])),,ASC)

It seems works well:

Now I want to use this measure instead of real ID. But it seems Matrix Columns doesn't support measures.

Please help to guide how to implement it.

[v-luwang-msft]

Hi @kongyuancn ,

Hi @Anonymous ,

If you want the measure to show up as column headers, you could create one measure for each category, and then include all of the measures in the Matrix (or Table).Other than that, I can't think of any other fa that can be achieved.

Refer:

https://community.powerbi.com/t5/Desktop/Add-a-measure-to-Column-in-Matrix-visual/m-p/668983 

https://www.goodly.co.in/measures-in-columns-matrix-powerbi/ 

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

Best Regards

Lucien

[amitchandak]

@kongyuancn , That will require dynamic segmentation. and still doubt you can get it

https://www.daxpatterns.com/dynamic-segmentation/
https://radacad.com/grouping-and-binning-step-towards-better-data-visualization

[kongyuancn]

Hi @amitchandak ， I read your link but it dosn't meet my requeirement.