create column of measures

[knasveschuk]

Is it possible to create a column of measures?

I have 30-50 measures I would like to add to a column so I can rank and get a cululative count

[v-lili6-msft]

hi  @knasveschuk 

A simple sample pbix file and expected output would help tremendously.
Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Regards,

Lin

[amitchandak]

@knasveschuk , creating a column from the measure will take the grand total. Try to think in terms of new measure. Or you need to convert few measures into columns

[mussaenda]

Hi @knasveschuk,

I think someone here did this already.

Check this file I found here.

https://gofile.io/d/DR3fbj

Hope this helps you

[AllisonKennedy]

Do you want this in a data model table or just in a matrix visual?
If matrix visual will work you could try show on rows, https://powerbi.microsoft.com/en-us/blog/tag/show-values-on-rows/

Or you could use SUMMARIZECOLUMNS or similar DAX To create the table yourself.

Either way will be messy with 30-50 measures, so ultimately might be best to consider what's in those measures and if there is a better way.

[tex628]

Hi @knasveschuk, 

I have a hard time understanding what you're after. 

What is it that you want to rank/count? 

Br,
J